APPS.GMS_PA_API3 dependencies on GMS_AWARDS_ALL

Line 1891: gms_awards_all ga

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

Line 2580: l_award_status gms_awards_all.status%TYPE ; --BUG 7225876

2576: l_start_date_min date;
2577: l_end_date_max date;
2578: l_debug varchar2(1) ;
2579: l_test number(1);
2580: l_award_status gms_awards_all.status%TYPE ; --BUG 7225876
2581: l_close_date gms_awards_all.close_date%TYPE ; -- BUG 7225876
2582: l_project_closed varchar2(1); -- BUG 7225876
2583:
2584: begin

Line 2581: l_close_date gms_awards_all.close_date%TYPE ; -- BUG 7225876

2577: l_end_date_max date;
2578: l_debug varchar2(1) ;
2579: l_test number(1);
2580: l_award_status gms_awards_all.status%TYPE ; --BUG 7225876
2581: l_close_date gms_awards_all.close_date%TYPE ; -- BUG 7225876
2582: l_project_closed varchar2(1); -- BUG 7225876
2583:
2584: begin
2585: L_DEBUG := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N'); -- to generate debug messages

Line 2600: from gms_awards_all aw

2596:
2597: begin /* added for bug 7225876 */
2598: select aw.status, aw.close_date
2599: into l_award_status,l_close_date
2600: from gms_awards_all aw
2601: where aw.award_id = p_award_id;
2602: exception
2603: when others then
2604: l_award_status := null;