APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS_S

Line 938: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

934:
935: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
936: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
937: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
938: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
939: UPDATE JAI_CMN_RG_I_TRXS
940: SET register_id_part_ii = v_rg23_part_ii_no,
941: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
942: WHERE register_id = v_rg23_part_ii_no)

Line 955: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

951: END IF;
952: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
953: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
954: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
955: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
956: UPDATE JAI_CMN_RG_23AC_I_TRXS
957: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
958: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
959: WHERE register_id = v_rg23_part_ii_no)