DBA Data[Home] [Help]

APPS.JAI_RCV_RND_PKG dependencies on GL_LEDGERS

Line 1859: * gl_sets_of_books and included gl_ledgers.

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

Line 1864: FROM gl_ledgers gle,gl_periods gd

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