APPS.JA_CN_JE_EXP_PKG dependencies on GL_PERIOD_STATUSES

Line 91: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;

87: l_functional_currency fnd_currencies_vl.NAME%TYPE;
88:
89: l_start_date DATE;
90: l_end_date DATE;
91: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;
92: l_current_start_date DATE;
93:
94: l_sql_stmt4insert_j_line CONSTANT VARCHAR2(30000) := 'INSERT INTO ja_cn_journal_lines_gt
95: (journal_number,

Line 240: FROM GL_PERIOD_STATUSES

236: WHERE legal_entity_id = p_legal_entity_id
237: AND chart_of_accounts_id = p_coa_id)
238: AND period_name IN
239: (SELECT period_name
240: FROM GL_PERIOD_STATUSES
241: WHERE ledger_id = p_ledger_id
242: AND application_id = 101
243: AND ((start_date BETWEEN l_start_date AND l_end_date) AND
244: (end_date BETWEEN l_start_date AND l_end_date)))

Line 257: FROM GL_PERIOD_STATUSES

253: ORDER BY start_date, to_number(journal_number), to_number(je_line_num);
254:
255: CURSOR c_in_closed_periods IS
256: SELECT period_name
257: FROM GL_PERIOD_STATUSES
258: WHERE ledger_id = p_ledger_id--set_of_books_id = l_set_of_books_id
259: AND application_id = 101
260: AND ((start_date BETWEEN l_start_date AND l_end_date) AND
261: (end_date BETWEEN l_start_date AND l_end_date))

Line 351: FROM GL_PERIOD_STATUSES

347:
348: --fetch start data and end date
349: SELECT start_date
350: INTO l_start_date
351: FROM GL_PERIOD_STATUSES
352: WHERE ledger_id = p_ledger_id--set_of_books_id = l_set_of_books_id
353: AND application_id = 101
354: AND period_name = p_start_period;
355:

Line 358: FROM GL_PERIOD_STATUSES

354: AND period_name = p_start_period;
355:
356: SELECT end_date
357: INTO l_end_date
358: FROM GL_PERIOD_STATUSES
359: WHERE ledger_id = p_ledger_id --set_of_books_id = l_set_of_books_id
360: AND application_id = 101
361: AND period_name = p_end_period;
362:

Line 502: FROM GL_PERIOD_STATUSES

498:
499: --fetch start date of current period
500: SELECT start_date
501: INTO l_current_start_date
502: FROM GL_PERIOD_STATUSES
503: WHERE ledger_id = p_ledger_id--set_of_books_id = l_set_of_books_id
504: AND application_id = 101
505: AND period_name = l_current_period;
506: