APPS.GMS_BILLING dependencies on PA_PROJECTS_ALL

Line 1001: pa_projects_all p,

997: adl.adl_line_num adl_line_num,
998: adl.award_id award_id
999: from pa_expenditure_items_all ei,
1000: pa_expenditure_types et,
1001: pa_projects_all p,
1002: pa_project_types pt,
1003: pa_tasks t3,
1004: pa_tasks t5,
1005: gms_award_distributions adl

Line 1386: pa_projects_all p,

1382: adl.expenditure_item_id,
1383: adl.adl_line_num,
1384: adl.award_id
1385: from pa_expenditure_items_all ei,
1386: pa_projects_all p,
1387: pa_project_types pt,
1388: pa_tasks t3,
1389: pa_tasks t5,
1390: gms_award_distributions adl

Line 2374: PA_PROJECTS_ALL a,

2370: a.non_labor_invoice_format_id,
2371: b.award_id, /*Award_Id*/
2372: a.carrying_out_organization_id
2373: from
2374: PA_PROJECTS_ALL a,
2375: GMS_AWARDS b
2376: where
2377: a.project_id = X_Project_Id and
2378: b.award_project_id = a.project_id ;

Line 4152: pa_projects_all a,

4148: Ins_Act_Proj_Num,
4149: Ins_Act_Task_Num,
4150: Ins_Exp_Org_Name
4151: from
4152: pa_projects_all a,
4153: pa_tasks b,
4154: hr_organization_units c
4155: where a.project_id = Ins_Actual_Project_Id and
4156: b.task_id = Ins_Actual_Task_Id and

Line 4434: pa_projects_all a,

4430: Ins_Act_Proj_Num,
4431: Ins_Act_Task_Num,
4432: Ins_Exp_Org_Name
4433: from
4434: pa_projects_all a,
4435: pa_tasks b,
4436: hr_organization_units c
4437: where a.project_id = X_Act_Project_Id and
4438: b.task_id = X_Task_Id and

Line 5559: ,pa_projects_all p

5555: ,pa_expenditure_items_all ei
5556: ,pa_expenditures e
5557: ,pa_expenditure_types et
5558: ,pa_lookups unit
5559: ,pa_projects_all p
5560: ,pa_project_types pt
5561: ,pa_tasks t3
5562: ,pa_tasks t5
5563: where

Line 6617: PA_PROJECTS_ALL

6613: into --doesn't have access to GET_FORMAT_SELECT
6614: X_Project_Type,
6615: X_Rev_Carrying_Out_Org_Id
6616: from
6617: PA_PROJECTS_ALL
6618: where
6619: project_id = X_Project_Id;
6620:
6621: EXCEPTION

Line 6823: ||' pa_projects_all p, pa_project_types pt,'

6819: nvl(ei.override_to_organization_id,e.incurred_by_organization_id),adl.ind_compiled_Set_id,adl.burdenable_raw_cost,
6820: ei.transaction_source '; --bug 2909746
6821:
6822: X_Fixed_From := 'pa_expenditure_items_all ei ,pa_expenditures_all e, pa_expenditure_types et,'
6823: ||' pa_projects_all p, pa_project_types pt,'
6824: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';
6825:
6826: /* --- 11.5 changes --- */
6827: --1. gms_award_distributions added in the from clause