APPS.JAI_RCV_JOURNAL_PKG dependencies on GL_LEDGERS

Line 57: * gl_sets_of_books and included gl_ledgers.

53:
54: /* Bug 5243532. Added by Lakshmi Gopalsami
55: * Removed org_organization_definitions from the cursor c_period_name
56: * and passed set_of_books_id to the cursor. Also removed
57: * gl_sets_of_books and included gl_ledgers.
58: */
59:
60: CURSOR c_period_name(cp_set_of_books_id IN NUMBER, cp_transaction_date IN DATE) IS
61: SELECT gd.period_name

Line 62: FROM gl_ledgers gle, gl_periods gd

58: */
59:
60: CURSOR c_period_name(cp_set_of_books_id IN NUMBER, cp_transaction_date IN DATE) IS
61: SELECT gd.period_name
62: FROM gl_ledgers gle, gl_periods gd
63: WHERE gle.ledger_id = cp_set_of_books_id
64: AND gd.period_set_name = gle.period_set_name
65: AND cp_transaction_date BETWEEN gd.start_date and gd.end_date
66: AND gd.adjustment_period_flag = 'N';