APPS.JAI_RCV_RND_PKG dependencies on GL_PERIODS

Line 1841: v_period_name GL_PERIODS.period_name%TYPE;

1837: ) IS
1838:
1839: v_organization_code ORG_ORGANIZATION_DEFINITIONS.organization_code%TYPE;
1840: --v_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%TYPE;
1841: v_period_name GL_PERIODS.period_name%TYPE;
1842:
1843: v_transaction_type VARCHAR2(20);
1844: --v_shipment_header_id NUMBER;
1845:

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';