APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS_S

Line 732: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;

728: v_customer_trx_id, SYSDATE, v_reg_code,
729: v_creation_date, v_created_by,v_last_update_date,
730: v_last_updated_by, v_last_update_login );
731: vsqlstmt := '22';
732: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
733: END IF;
734: END IF;
735: IF v_reg_code in ('DOMESTIC_EXCISE','EXPORT_EXCISE') THEN
736:

Line 847: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;

843: WHERE register_id = v_pla_register_no)
844: WHERE register_id = v_rg23_part_i_no;
845: END IF;
846: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
847: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
848: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
849: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
850: UPDATE JAI_CMN_RG_23AC_I_TRXS
851: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,