PSB Worksheet Submission Status

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