[Home] [Help]
3823: SET (bc.bud_task_id, bc.top_task_id) =
3824: (SELECT DECODE (bem.entry_level_code, 'P', 0, 'L', bc.task_id, t.top_task_id),
3825: DECODE (bem.entry_level_code, 'P', 0, t.top_task_id)
3826: FROM pa_budget_entry_methods bem, gms_budget_versions bv,
3827: pa_tasks t
3828: WHERE bv.budget_version_id = bc.budget_version_id
3829: AND bv.budget_entry_method_code = bem.budget_entry_method_code
3830: AND bem.entry_level_code IN ('P', 'L', 'T')
3831: AND t.task_id = bc.task_id)
3852: SET (bc.bud_task_id, bc.top_task_id) =
3853: (SELECT t.task_id,
3854: t.top_task_id
3855: FROM pa_budget_entry_methods bem, gms_budget_versions bv,
3856: pa_tasks t
3857: WHERE bv.budget_version_id = bc.budget_version_id
3858: AND bv.budget_entry_method_code = bem.budget_entry_method_code
3859: AND bem.entry_level_code = 'M'
3860: AND t.task_id = (SELECT task_id
3876: UPDATE gms_bc_packets bc
3877: SET (bc.bud_task_id, bc.top_task_id) =
3878: (SELECT t.task_id,
3879: t.top_task_id
3880: FROM pa_budget_entry_methods bem, gms_budget_versions bv,pa_tasks t
3881: WHERE bv.budget_version_id = bc.budget_version_id
3882: AND bv.budget_entry_method_code = bem.budget_entry_method_code
3883: AND bem.entry_level_code = 'M'
3884: AND t.task_id = (SELECT task_id
3883: AND bem.entry_level_code = 'M'
3884: AND t.task_id = (SELECT task_id
3885: FROM gms_balances
3886: WHERE task_id = (SELECT top_task_id
3887: FROM pa_tasks
3888: WHERE task_id = bc.task_id)
3889: AND budget_version_id = bc.budget_version_id
3890: AND project_id = bc.project_id
3891: AND award_id = bc.award_id
3908: UPDATE gms_bc_packets bc
3909: SET (bc.bud_task_id, bc.top_task_id) =
3910: (SELECT t.task_id,
3911: t.top_task_id
3912: FROM pa_tasks t
3913: WHERE t.task_id = bc.task_id)
3914: WHERE bc.packet_id = x_packetid
3915: AND bc.bud_task_id IS NULL
3916: AND status_code = 'P'