APPS.JA_CN_FA_ACUI_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 435: FROM gl_period_statuses

431: --Fetch start data and end date
432: IF pv_period_from IS NOT NULL THEN
433: SELECT start_date, period_num
434: INTO ld_start_date, lv_period_name
435: FROM gl_period_statuses
436: WHERE ledger_id = pn_ledger_id
437: AND application_id = 101
438: AND period_name = pv_period_from
439: AND to_char(period_year) = pv_accounting_year;

Line 447: FROM gl_period_statuses

443:
444: IF pv_period_to IS NOT NULL THEN
445: SELECT end_date
446: INTO ld_end_date
447: FROM gl_period_statuses
448: WHERE ledger_id = pn_ledger_id
449: AND application_id = 101
450: AND period_name = pv_period_to
451: AND to_char(period_year) = pv_accounting_year;