DBA Data[Home] [Help]

APPS.JA_CN_FA_ACS_EXPORT_PKG dependencies on GL_PERIOD_STATUSES

Line 214: FROM gl_period_statuses

210: IF pv_period_from IS NOT NULL
211: THEN
212: SELECT start_date
213: INTO ld_start_date
214: FROM gl_period_statuses
215: WHERE ledger_id = pn_ledger_id
216: AND application_id = 101
217: AND period_name = pv_period_from
218: AND to_char(period_year) = pv_accounting_year;

Line 227: FROM gl_period_statuses

223: IF pv_period_to IS NOT NULL
224: THEN
225: SELECT end_date
226: INTO ld_end_date
227: FROM gl_period_statuses
228: WHERE ledger_id = pn_ledger_id
229: AND application_id = 101
230: AND period_name = pv_period_to
231: AND to_char(period_year) = pv_accounting_year;