DBA Data[Home] [Help]

APPS.JAI_RCV_RND_PKG dependencies on GL_LEDGERS

Line 1860: * gl_sets_of_books and included gl_ledgers.

1856: /* Bug 5243532. Added by Lakshmi Gopalsami
1857: * Removed org_organization_definitions from the
1858: * cursor c_orgn_code_n_period_name
1859: * and passed set_of_books_id to the cursor. Also removed
1860: * gl_sets_of_books and included gl_ledgers.
1861: */
1862:
1863: CURSOR c_orgn_code_n_period_name(cp_set_of_books_id IN NUMBER) IS
1864: SELECT gd.period_name

Line 1865: FROM gl_ledgers gle,gl_periods gd

1861: */
1862:
1863: CURSOR c_orgn_code_n_period_name(cp_set_of_books_id IN NUMBER) IS
1864: SELECT gd.period_name
1865: FROM gl_ledgers gle,gl_periods gd
1866: WHERE gle.ledger_id = cp_set_of_books_id
1867: AND gd.period_set_name = gle.period_set_name
1868: AND trunc(p_transaction_date) BETWEEN gd.start_date and gd.end_date
1869: AND adjustment_period_flag='N';