ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F43B3869E053B46B63588994Y SELECT ws.worksheet_id Worksheet_ID1, ws.budget_group_id budget_group_id2, bg.name Budget_Group, DECODE(ws.date_submitted, NULL, 'N','Y') Submitted FROM psb_worksheets ws, psb_budget_groups bg WHERE ws.global_worksheet_id = :cp_global_worksheet_id AND NVL(ws.global_worksheet_flag, 'N') <> 'Y' AND NVL(ws.local_copy_flag, 'N') <> 'Y' AND bg.budget_group_id = ws.budget_group_id AND DECODE( ws.date_submitted, NULL, 'N', 'Y') = DECODE ( :p_not_submitted_only_flag, 'Y', 'N', DECODE(ws.date_submitted, NULL, 'N', 'Y') ) and ws.budget_group_id=:budget_group_id1 PSB PSBWSSUB_XML US PSB Worksheet Submission Status Application: Public Sector Budgeting (Obsolete) Source: Worksheet Submission Status Report (XML) Short Name: PSBWSSUB_XML DB package: PSB_PSBWSSUB_XMLP_PKG BI Publisher :budget_group_id1 :cp_global_worksheet_id :p_not_submitted_only_flag 1 10 :p_budget_group_id LOV Oracle PSB_SRS_BUDGET_GROUP_NAME Y select budget_group_id id, name value, null description from psb_budget_groups where budget_group_type='R' order by name Y US Budget Group Name 2 20 :p_worksheet_id LOV Oracle PSB_WORKSHEET_BY_BUDGET_GROUP Y select worksheet_id id, worksheet_id value, name description from psb_worksheets where budget_group_id=:$flex$.psb_srs_budget_group_name order by name Y US Worksheet 3 30 :p_not_submitted_only_flag LOV Oracle PSB_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description N Y US Print Not Submitted Only