APPS.GMS_COST_PLUS_EXTN dependencies on PA_TASKS

Line 1073: FROM pa_tasks

1069: PROCEDURE update_top_tsk_par_res (x_packet_id IN NUMBER) IS
1070: BEGIN
1071: UPDATE gms_bc_packets pkt
1072: SET pkt.top_task_id = (SELECT top_task_id
1073: FROM pa_tasks
1074: WHERE task_id = pkt.task_id)
1075: WHERE pkt.packet_id = x_packet_id
1076: AND pkt.top_task_id IS NULL;
1077:

Line 1093: p_task_id pa_tasks.task_id%type,

1089: -- create_burden_adjustments : Function creates burden adjusmtent entry in gms_bc_packets
1090: -- -------------------------------------------------------------------------
1091: PROCEDURE create_burden_adjustments(p_rec_log gms_burden_adjustments_log%ROWTYPE,
1092: p_project_id pa_projects_all.project_id%type,
1093: p_task_id pa_tasks.task_id%type,
1094: p_expenditure_item_date gms_bc_packets.expenditure_item_date%type,
1095: p_expenditure_org_id gms_bc_packets.expenditure_organization_id%type,
1096: p_rlmi gms_bc_packets.resource_list_member_id%type,
1097: p_bud_task_id gms_bc_packets.bud_task_id%type,

Line 1138: from pa_tasks

1134: l_stage := 'Derive Top Task';
1135:
1136: Select top_task_id
1137: into l_top_task_id
1138: from pa_tasks
1139: where task_id = p_task_id;
1140:
1141: -- Get parent_member_id
1142: l_stage := 'Derive Parent Resource';

Line 1357: FROM pa_tasks

1353: l_task_id NUMBER;
1354:
1355: CURSOR prj_task IS
1356: SELECT project_id, top_task_id
1357: FROM pa_tasks
1358: WHERE task_id = x_task_id;
1359:
1360: CURSOR override_schedule_task( l_task_id number) IS
1361: SELECT idc_schedule_id, cost_ind_sch_fixed_date