APPS.GMS_COST_PLUS_EXTN dependencies on PA_TASKS

Line 806: FROM pa_tasks

802: PROCEDURE update_top_tsk_par_res (x_packet_id IN NUMBER) IS
803: BEGIN
804: UPDATE gms_bc_packets pkt
805: SET pkt.top_task_id = (SELECT top_task_id
806: FROM pa_tasks
807: WHERE task_id = pkt.task_id)
808: WHERE pkt.packet_id = x_packet_id
809: AND pkt.top_task_id IS NULL;
810:

Line 826: p_task_id pa_tasks.task_id%type,

822: -- create_burden_adjustments : Function creates burden adjusmtent entry in gms_bc_packets
823: -- -------------------------------------------------------------------------
824: PROCEDURE create_burden_adjustments(p_rec_log gms_burden_adjustments_log%ROWTYPE,
825: p_project_id pa_projects_all.project_id%type,
826: p_task_id pa_tasks.task_id%type,
827: p_expenditure_item_date gms_bc_packets.expenditure_item_date%type,
828: p_expenditure_org_id gms_bc_packets.expenditure_organization_id%type,
829: p_rlmi gms_bc_packets.resource_list_member_id%type,
830: p_bud_task_id gms_bc_packets.bud_task_id%type,

Line 871: from pa_tasks

867: l_stage := 'Derive Top Task';
868:
869: Select top_task_id
870: into l_top_task_id
871: from pa_tasks
872: where task_id = p_task_id;
873:
874: -- Get parent_member_id
875: l_stage := 'Derive Parent Resource';

Line 1090: FROM pa_tasks

1086: l_task_id NUMBER;
1087:
1088: CURSOR prj_task IS
1089: SELECT project_id, top_task_id
1090: FROM pa_tasks
1091: WHERE task_id = x_task_id;
1092:
1093: CURSOR override_schedule_task( l_task_id number) IS
1094: SELECT idc_schedule_id, cost_ind_sch_fixed_date