APPS.JAI_RCV_RND_PKG dependencies on GL_PERIODS

Line 1840: v_period_name GL_PERIODS.period_name%TYPE;

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

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