DBA Data[Home] [Help]

APPS.PA_PERIOD_PROCESS_PKG dependencies on GL_PERIOD_STATUSES

Line 110: from pa_periods a, gl_period_statuses b

106:
107: cursor c_periods is
108: select b.period_name, b.closing_status, b.set_of_books_id ,
109: b.last_update_date, b.last_updated_by, b.last_update_login /* added bug 3111150 */
110: from pa_periods a, gl_period_statuses b
111: where a.period_name = b.period_name
112: and b.application_id = 8721
113: and b.set_of_books_id = (select set_of_books_id from pa_implementations)
114: and a.start_date = b.start_date

Line 209: gl_period_statuses gl

205: --where the the pa_period staus does not match the gl_period status
206: CURSOR c_Mismatch_Status IS
207: SELECT pa.period_name
208: FROM pa_periods pa,
209: gl_period_statuses gl
210: WHERE gl.set_of_books_id=p_sob_id
211: AND gl.application_id=8721
212: AND pa.period_name=gl.period_name
213: AND pa.status <>gl.closing_status;