APPS.GMS_SWEEPER dependencies on GL_PERIOD_STATUSES

Line 499: from gl_period_statuses gps

495: If x_start_date is NULL then
496:
497: select gps.start_date, gps.end_date
498: into x_start_date, x_end_date
499: from gl_period_statuses gps
500: where gps.application_id = 101
501: and gps.set_of_books_id = x_set_of_books_id
502: and trunc(x_expenditure_item_date) between gps.start_date and gps.end_date
503: and gps.adjustment_period_flag = 'N';

Line 1267: from gl_period_statuses gps

1263:
1264: if x_time_phased_type_code = 'G' then
1265: select gps.start_date, gps.end_date
1266: into x_start_date, x_end_date
1267: from gl_period_statuses gps
1268: where gps.application_id = 101
1269: and gps.set_of_books_id = x_set_of_books_id
1270: and /*rev_gen.expenditure_item_date for bug 5481465*/ l_ei_date_tbl(i) between gps.start_date and gps.end_date
1271: and gps.adjustment_period_flag = 'N';

Line 1822: from gl_period_statuses gps

1818:
1819: if rec_gms_packets.time_phased_type_code = 'G' then
1820: select gps.start_date, gps.end_date
1821: into x_st_date, x_ed_date
1822: from gl_period_statuses gps
1823: where gps.application_id = 101
1824: and gps.set_of_books_id = rec_gms_packets.set_of_books_id
1825: and rec_gms_packets.expenditure_item_date between gps.start_date and gps.end_date
1826: and gps.adjustment_period_flag = 'N';