APPS.GMS_PA_API3 dependencies on GMS_AWARDS

Line 151: gms_awards ga

147:
148: select 'Y'
149: into l_award_same
150: from gms_award_distributions adl,
151: gms_awards ga
152: where adl.expenditure_item_id = p_expenditure_item_id
153: and adl.document_type = 'EXP'
154: and adl.adl_status = 'A'
155: and adl.adl_line_num = 1

Line 1889: gms_awards_all ga

1885: /* Added for Bug 5645290 */
1886: FROM PA_PROJ_AP_INV_DISTRIBUTIONS PPAID,
1887: GMS_AWARD_DISTRIBUTIONS ADL,
1888: gms_allowable_expenditures gae,
1889: gms_awards_all ga
1890: WHERE PPAID.project_id = p_start_project_id
1891: and ga.award_id = adl.award_id
1892: and gae.allowability_schedule_id = ga.allowable_schedule_id
1893: and gae.expenditure_type = PPAID.expenditure_type