DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on GL_PERIOD_STATUSES

Line 3756: FROM gl_period_statuses

3752: AND location_id = cp_location_id ;
3753:
3754: CURSOR c_gl_periods(cp_set_of_books_id IN NUMBER) IS
3755: SELECT period_name
3756: FROM gl_period_statuses
3757: where set_of_books_id = cp_set_of_books_id
3758: and sysdate between start_Date and end_Date
3759: and application_id = 101;
3760:

Line 3762: lv_period_name gl_period_statuses.period_name%type;

3758: and sysdate between start_Date and end_Date
3759: and application_id = 101;
3760:
3761:
3762: lv_period_name gl_period_statuses.period_name%type;
3763: ln_shipment_line_id NUMBER;
3764: ln_register_id NUMBER;
3765: lv_process_status VARCHAR2(20);
3766: lv_process_message VARCHAR2(2000);