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 1278: from gl_period_statuses gps

1274:
1275: if x_time_phased_type_code = 'G' then
1276: select gps.start_date, gps.end_date
1277: into x_start_date, x_end_date
1278: from gl_period_statuses gps
1279: where gps.application_id = 101
1280: and gps.set_of_books_id = x_set_of_books_id
1281: and /*rev_gen.expenditure_item_date for bug 5481465*/ l_ei_date_tbl(i) between gps.start_date and gps.end_date
1282: and gps.adjustment_period_flag = 'N';

Line 1833: from gl_period_statuses gps

1829:
1830: if rec_gms_packets.time_phased_type_code = 'G' then
1831: select gps.start_date, gps.end_date
1832: into x_st_date, x_ed_date
1833: from gl_period_statuses gps
1834: where gps.application_id = 101
1835: and gps.set_of_books_id = rec_gms_packets.set_of_books_id
1836: and rec_gms_packets.expenditure_item_date between gps.start_date and gps.end_date
1837: and gps.adjustment_period_flag = 'N';