[Home] [Help]
4129: SET (bc.bud_task_id, bc.top_task_id) =
4130: (SELECT DECODE (bem.entry_level_code, 'P', 0, 'L', bc.task_id, t.top_task_id),
4131: DECODE (bem.entry_level_code, 'P', 0, t.top_task_id)
4132: FROM pa_budget_entry_methods bem, gms_budget_versions bv,
4133: pa_tasks t
4134: WHERE bv.budget_version_id = bc.budget_version_id
4135: AND bv.budget_entry_method_code = bem.budget_entry_method_code
4136: AND bem.entry_level_code IN ('P', 'L', 'T')
4137: AND t.task_id = bc.task_id)
4158: SET (bc.bud_task_id, bc.top_task_id) =
4159: (SELECT t.task_id,
4160: t.top_task_id
4161: FROM pa_budget_entry_methods bem, gms_budget_versions bv,
4162: pa_tasks t
4163: WHERE bv.budget_version_id = bc.budget_version_id
4164: AND bv.budget_entry_method_code = bem.budget_entry_method_code
4165: AND bem.entry_level_code = 'M'
4166: AND t.task_id = (SELECT task_id
4182: UPDATE gms_bc_packets bc
4183: SET (bc.bud_task_id, bc.top_task_id) =
4184: (SELECT t.task_id,
4185: t.top_task_id
4186: FROM pa_budget_entry_methods bem, gms_budget_versions bv,pa_tasks t
4187: WHERE bv.budget_version_id = bc.budget_version_id
4188: AND bv.budget_entry_method_code = bem.budget_entry_method_code
4189: AND bem.entry_level_code = 'M'
4190: AND t.task_id = (SELECT task_id
4189: AND bem.entry_level_code = 'M'
4190: AND t.task_id = (SELECT task_id
4191: FROM gms_balances
4192: WHERE task_id = (SELECT top_task_id
4193: FROM pa_tasks
4194: WHERE task_id = bc.task_id)
4195: AND budget_version_id = bc.budget_version_id
4196: AND project_id = bc.project_id
4197: AND award_id = bc.award_id
4214: UPDATE gms_bc_packets bc
4215: SET (bc.bud_task_id, bc.top_task_id) =
4216: (SELECT t.task_id,
4217: t.top_task_id
4218: FROM pa_tasks t
4219: WHERE t.task_id = bc.task_id)
4220: WHERE bc.packet_id = x_packetid
4221: AND bc.bud_task_id IS NULL
4222: AND status_code = 'P'