APPS.JA_CN_APAB_EXPORT_PKG dependencies on GL_PERIOD_STATUSES

Line 199: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;

195: '.account_segment =s.account_segment_value)';
196:
197: ld_start_date DATE;
198: ld_end_date DATE;
199: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;
200: ld_current_start_date DATE;
201:
202: --cursors start here
203: CURSOR c_in_ja_cn_dff_assignments

Line 223: FROM GL_PERIOD_STATUSES

219: WHERE legal_entity_id = pn_legal_entity_id
220: AND chart_of_accounts_id = pn_coa_id)
221: AND period_name IN
222: (SELECT period_name
223: FROM GL_PERIOD_STATUSES
224: WHERE ledger_id = pn_ledger_id
225: AND application_id = 101
226: AND ((start_date BETWEEN ld_start_date AND ld_end_date) AND
227: (end_date BETWEEN ld_start_date AND ld_end_date)))

Line 237: FROM GL_PERIOD_STATUSES

233:
234: CURSOR c_in_closed_periods
235: IS
236: SELECT period_name
237: FROM GL_PERIOD_STATUSES
238: WHERE ledger_id = pn_ledger_id
239: AND application_id = 101
240: AND ((start_date BETWEEN ld_start_date AND ld_end_date) AND
241: (end_date BETWEEN ld_start_date AND ld_end_date))

Line 291: FROM GL_PERIOD_STATUSES

287: --Fetch start data and end date
288: IF pv_period_from IS NOT NULL THEN
289: SELECT start_date
290: INTO ld_start_date
291: FROM GL_PERIOD_STATUSES
292: WHERE ledger_id = pn_ledger_id
293: AND application_id = 101
294: AND period_name = pv_period_from
295: AND TO_CHAR(period_year) = pv_accounting_year;

Line 303: FROM GL_PERIOD_STATUSES

299:
300: IF pv_period_to IS NOT NULL THEN
301: SELECT end_date
302: INTO ld_end_date
303: FROM GL_PERIOD_STATUSES
304: WHERE ledger_id = pn_ledger_id
305: AND application_id = 101
306: AND period_name = pv_period_to
307: AND TO_CHAR(period_year) = pv_accounting_year;

Line 484: FROM GL_PERIOD_STATUSES

480:
481: --Fetch start date of current period
482: SELECT start_date
483: INTO ld_current_start_date
484: FROM GL_PERIOD_STATUSES
485: WHERE ledger_id = pn_ledger_id
486: AND application_id = 101
487: AND period_name = l_current_period;
488: