APPS.IGC_CBC_PA_BC_PKG dependencies on GL_PERIOD_STATUSES

Line 231: FROM gl_period_statuses per

227: SET v1.pa_flag = 'Y',
228: v1.result_code_source = 'P',
229: v1.period_name =
230: ( SELECT min(per.period_name)
231: FROM gl_period_statuses per
232: WHERE per.application_id = 101
233: AND per.adjustment_period_flag='N'
234: AND per.set_of_books_id = p_sobid
235: AND v1.cc_transaction_date