APPS.GMS_SWEEPER dependencies on PA_PERIODS

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

1283:
1284: elsif x_time_phased_type_code = 'P' then
1285: select start_date , end_date
1286: into x_start_date , x_end_date
1287: from pa_periods gpa /* Bug 6721990: Replaced pa_periods_all with pa_periods */
1288: where /* rev_gen.expenditure_item_date for bug 5481465 */ l_ei_date_tbl(i) between gpa.start_date and gpa.end_date;
1289:
1290: elsif x_time_phased_type_code in ('R','N') then
1291:

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

1838:
1839: elsif rec_gms_packets.time_phased_type_code = 'P' then
1840: select start_date , end_date
1841: into x_st_date , x_ed_date
1842: from pa_periods gpa --Bug 4732065 /*bug 6660289*/
1843: where rec_gms_packets.expenditure_item_date between gpa.start_date and gpa.end_date;
1844:
1845: elsif rec_gms_packets.time_phased_type_code in ('R','N') then
1846: