PSB Worksheet Submission Status

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Worksheet Submission Status Report (XML)
Short Name: PSBWSSUB_XML
DB package: PSB_PSBWSSUB_XMLP_PKG
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
Parameter NameSQL textValidation
Budget Group Name
 
LOV Oracle
Worksheet
 
LOV Oracle
Print Not Submitted Only
 
LOV Oracle
Download
Related Blitz Reports
PSB Vacant Position PSB Service Package Description PSB Vacant Position Report by Responsibility PSB Service Package Utilization PSB Stage Variance Report for Position by Responsibility PSB Stage Variance Report for Account by Responsibility PSB Worksheet Account Costing PSB Stage Variance Report for Position PSB Worksheet Account Costing Report By Responsibility
Blitz Report™