DBA Data[Home] [Help]

APPS.PA_SWEEPER dependencies on GL_PERIOD_STATUSES

Line 32: from gl_period_statuses gps

28:
29: IF p_time_phase_code = 'G' then
30: select gps.start_date
31: into l_st_date
32: from gl_period_statuses gps
33: where gps.application_id = 101
34: and gps.set_of_books_id = p_sob_id
35: and trunc(p_gl_date) between trunc(gps.start_date) and trunc(gps.end_date)
36: and gps.adjustment_period_flag = 'N';

Line 124: from gl_period_statuses gps

120:
121: IF p_time_phase_code = 'G' then
122: select gps.end_date
123: into l_ed_date
124: from gl_period_statuses gps
125: where gps.application_id = 101
126: and gps.set_of_books_id = p_sob_id
127: and trunc(p_gl_date) between trunc(gps.start_date) and trunc(gps.end_date)
128: and gps.adjustment_period_flag = 'N';