APPS.GMS_BILLING dependencies on PA_PROJECT_TYPES

Line 995: select /*+INDEX(pt PA_PROJECT_TYPES_U1)*/

991: X_Err_Code IN OUT NOCOPY NUMBER,
992: X_Err_Buff IN OUT NOCOPY VARCHAR2) IS
993: /* This Cursor fetches expenditure items on ONE TIME BILL HOLD */
994: Cursor one_time_hold is
995: select /*+INDEX(pt PA_PROJECT_TYPES_U1)*/
996: ei.expenditure_item_id expenditure_item_id,
997: adl.adl_line_num adl_line_num,
998: adl.award_id award_id
999: from pa_expenditure_items_all ei,

Line 1002: pa_project_types pt,

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
1006: where adl.award_id = X_Award_Id

Line 1387: pa_project_types pt,

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
1391: where adl.award_id = X_Award_Id

Line 5560: ,pa_project_types pt

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
5564: adl.award_id = X_Award_Id

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