APPS.JA_CN_FA_AC_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 106: FROM gl_period_statuses

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

Line 118: FROM gl_period_statuses

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

Line 538: FROM gl_period_statuses

534: --Fetch start data and end date
535: IF pv_period_from IS NOT NULL THEN
536: SELECT start_date, period_num
537: INTO ld_start_date, lv_accounting_period
538: FROM gl_period_statuses
539: WHERE ledger_id = pn_ledger_id
540: AND application_id = 101
541: AND period_name = pv_period_from
542: AND to_char(period_year) = pv_accounting_year;

Line 550: FROM gl_period_statuses

546:
547: IF pv_period_to IS NOT NULL THEN
548: SELECT end_date
549: INTO ld_end_date
550: FROM gl_period_statuses
551: WHERE ledger_id = pn_ledger_id
552: AND application_id = 101
553: AND period_name = pv_period_to
554: AND to_char(period_year) = pv_accounting_year;