APPS.GMS_SWEEPER dependencies on PA_PERIODS

Line 1276: from pa_periods gpa /* Bug 6721990: Replaced pa_periods_all with pa_periods */

1272:
1273: elsif x_time_phased_type_code = 'P' then
1274: select start_date , end_date
1275: into x_start_date , x_end_date
1276: from pa_periods gpa /* Bug 6721990: Replaced pa_periods_all with pa_periods */
1277: where /* rev_gen.expenditure_item_date for bug 5481465 */ l_ei_date_tbl(i) between gpa.start_date and gpa.end_date;
1278:
1279: elsif x_time_phased_type_code in ('R','N') then
1280:

Line 1831: from pa_periods gpa --Bug 4732065 /*bug 6660289*/

1827:
1828: elsif rec_gms_packets.time_phased_type_code = 'P' then
1829: select start_date , end_date
1830: into x_st_date , x_ed_date
1831: from pa_periods gpa --Bug 4732065 /*bug 6660289*/
1832: where rec_gms_packets.expenditure_item_date between gpa.start_date and gpa.end_date;
1833:
1834: elsif rec_gms_packets.time_phased_type_code in ('R','N') then
1835: