DBA Data[Home] [Help]

APPS.JA_CN_FA_BI_EXPORT_PKG dependencies on GL_PERIOD_STATUSES

Line 241: FROM gl_period_statuses

237: IF pv_period_from IS NOT NULL
238: THEN
239: SELECT start_date
240: INTO ld_start_date
241: FROM gl_period_statuses
242: WHERE ledger_id = pn_ledger_id
243: AND application_id = 101
244: AND period_name = pv_period_from
245: AND to_char(period_year) = pv_accounting_year;

Line 254: FROM gl_period_statuses

250: IF pv_period_to IS NOT NULL
251: THEN
252: SELECT end_date
253: INTO ld_end_date
254: FROM gl_period_statuses
255: WHERE ledger_id = pn_ledger_id
256: AND application_id = 101
257: AND period_name = pv_period_to
258: AND to_char(period_year) = pv_accounting_year;