APPS.JAI_MTL_TRXS_PKG dependencies on GL_PERIOD_STATUSES

Line 3592: FROM gl_period_statuses

3588: AND location_id = cp_location_id ;
3589:
3590: CURSOR c_gl_periods(cp_set_of_books_id IN NUMBER) IS
3591: SELECT period_name
3592: FROM gl_period_statuses
3593: where set_of_books_id = cp_set_of_books_id
3594: and sysdate between start_Date and end_Date
3595: and application_id = 101;
3596:

Line 3598: lv_period_name gl_period_statuses.period_name%type;

3594: and sysdate between start_Date and end_Date
3595: and application_id = 101;
3596:
3597:
3598: lv_period_name gl_period_statuses.period_name%type;
3599: ln_shipment_line_id NUMBER;
3600: ln_register_id NUMBER;
3601: lv_process_status VARCHAR2(20);
3602: lv_process_message VARCHAR2(2000);