APPS.JA_CN_FA_RAI_EXPORT_PKG dependencies on GL_PERIOD_STATUSES

Line 67: FROM gl_period_statuses fps

63: ln_row_count NUMBER := 0; --Add by Jianchao Chi for bug 11847991 on 2011-03-09
64:
65: CURSOR fa_export_period_cur IS
66: SELECT DISTINCT fps.period_name, fps.start_date, fps.end_date
67: FROM gl_period_statuses fps
68: WHERE ledger_id = pn_ledger_id --set_of_books_id = l_set_of_books_id
69: AND application_id = 101
70: AND fps.start_date >= ld_start_date
71: AND fps.end_date <= ld_end_date

Line 104: FROM gl_period_statuses

100: --Fetch start data and end date
101: IF pv_period_from IS NOT NULL THEN
102: SELECT start_date
103: INTO ld_start_date
104: FROM gl_period_statuses
105: WHERE ledger_id = pn_ledger_id
106: AND application_id = 101
107: AND period_name = pv_period_from
108: AND to_char(period_year) = pv_accounting_year;

Line 116: FROM gl_period_statuses

112:
113: IF pv_period_to IS NOT NULL THEN
114: SELECT end_date
115: INTO ld_end_date
116: FROM gl_period_statuses
117: WHERE ledger_id = pn_ledger_id
118: AND application_id = 101
119: AND period_name = pv_period_to
120: AND to_char(period_year) = pv_accounting_year;

Line 346: FROM gl_period_statuses

342: --Fetch start data and end date
343: IF pv_period_from IS NOT NULL THEN
344: SELECT start_date, period_num
345: INTO ld_start_date, ln_period_num
346: FROM gl_period_statuses
347: WHERE ledger_id = pn_ledger_id
348: AND application_id = 101
349: AND period_name = pv_period_from
350: AND to_char(period_year) = pv_accounting_year;

Line 358: FROM gl_period_statuses

354:
355: IF pv_period_to IS NOT NULL THEN
356: SELECT end_date
357: INTO ld_end_date
358: FROM gl_period_statuses
359: WHERE ledger_id = pn_ledger_id
360: AND application_id = 101
361: AND period_name = pv_period_to
362: AND to_char(period_year) = pv_accounting_year;