APPS.JA_CN_FA_MM_EXPORT_PKG dependencies on GL_PERIOD_STATUSES

Line 140: FROM gl_period_statuses

136: --Fetch start data and end date
137: IF pv_period_from IS NOT NULL THEN
138: SELECT start_date
139: INTO ld_start_date
140: FROM gl_period_statuses
141: WHERE ledger_id = pn_ledger_id
142: AND application_id = 101
143: AND period_name = pv_period_from
144: AND to_char(period_year) = pv_accounting_year;

Line 152: FROM gl_period_statuses

148:
149: IF pv_period_to IS NOT NULL THEN
150: SELECT end_date
151: INTO ld_end_date
152: FROM gl_period_statuses
153: WHERE ledger_id = pn_ledger_id
154: AND application_id = 101
155: AND period_name = pv_period_to
156: AND to_char(period_year) = pv_accounting_year;