APPS.JA_CN_AB_EXP_PKG dependencies on GL_PERIOD_STATUSES

Line 206: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;

202: l_output_format VARCHAR2(10) := P_XML_OUTPUT_FORMAT;
203:
204: l_start_date DATE;
205: l_end_date DATE;
206: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;
207: l_current_start_date DATE;
208: --exceptions start here
209: --sob_unfetchable EXCEPTION;
210:

Line 234: FROM GL_PERIOD_STATUSES

230: WHERE legal_entity_id = p_legal_entity
231: AND chart_of_accounts_id = p_coa_id)
232: AND period_name IN
233: (SELECT period_name
234: FROM GL_PERIOD_STATUSES
235: WHERE ledger_id = p_ledger_id--set_of_books_id = l_set_of_books_id
236: AND application_id = 101
237: AND ((start_date BETWEEN l_start_date AND l_end_date) AND
238: (end_date BETWEEN l_start_date AND l_end_date)))

Line 256: FROM GL_PERIOD_STATUSES

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

Line 347: FROM GL_PERIOD_STATUSES

343: */
344: --fetch start data and end date
345: SELECT start_date
346: INTO l_start_date
347: FROM GL_PERIOD_STATUSES
348: WHERE ledger_id = p_ledger_id--set_of_books_id = l_set_of_books_id
349: AND application_id = 101
350: AND period_name = p_start_period;
351:

Line 354: FROM GL_PERIOD_STATUSES

350: AND period_name = p_start_period;
351:
352: SELECT end_date
353: INTO l_end_date
354: FROM GL_PERIOD_STATUSES
355: WHERE ledger_id = p_ledger_id--set_of_books_id = l_set_of_books_id
356: AND application_id = 101
357: AND period_name = p_end_period;
358:

Line 560: FROM GL_PERIOD_STATUSES

556:
557: --fetch start date of current period
558: SELECT start_date
559: INTO l_current_start_date
560: FROM GL_PERIOD_STATUSES
561: WHERE ledger_id = p_ledger_id--set_of_books_id = l_set_of_books_id
562: AND application_id = 101
563: AND period_name = l_current_period;
564: