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 4127: pa_projects_all a,

4123: Ins_Act_Proj_Num,
4124: Ins_Act_Task_Num,
4125: Ins_Exp_Org_Name
4126: from
4127: pa_projects_all a,
4128: pa_tasks b,
4129: hr_organization_units c
4130: where a.project_id = Ins_Actual_Project_Id and
4131: b.task_id = Ins_Actual_Task_Id and

Line 4409: pa_projects_all a,

4405: Ins_Act_Proj_Num,
4406: Ins_Act_Task_Num,
4407: Ins_Exp_Org_Name
4408: from
4409: pa_projects_all a,
4410: pa_tasks b,
4411: hr_organization_units c
4412: where a.project_id = X_Act_Project_Id and
4413: b.task_id = X_Task_Id and

Line 5530: ,pa_projects_all p

5526: ,pa_expenditure_items_all ei
5527: ,pa_expenditures e
5528: ,pa_expenditure_types et
5529: ,pa_lookups unit
5530: ,pa_projects_all p
5531: ,pa_project_types pt
5532: ,pa_tasks t3
5533: ,pa_tasks t5
5534: where

Line 6586: PA_PROJECTS_ALL

6582: into --doesn't have access to GET_FORMAT_SELECT
6583: X_Project_Type,
6584: X_Rev_Carrying_Out_Org_Id
6585: from
6586: PA_PROJECTS_ALL
6587: where
6588: project_id = X_Project_Id;
6589:
6590: EXCEPTION

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

6788: nvl(ei.override_to_organization_id,e.incurred_by_organization_id),adl.ind_compiled_Set_id,adl.burdenable_raw_cost,
6789: ei.transaction_source '; --bug 2909746
6790:
6791: X_Fixed_From := 'pa_expenditure_items_all ei ,pa_expenditures_all e, pa_expenditure_types et,'
6792: ||' pa_projects_all p, pa_project_types pt,'
6793: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';
6794:
6795: /* --- 11.5 changes --- */
6796: --1. gms_award_distributions added in the from clause