APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS_S

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

828: END IF;
829: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
830: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
831: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
832: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
833: UPDATE JAI_CMN_RG_I_TRXS
834: SET register_id_part_ii = v_rg23_part_ii_no,
835: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
836: WHERE register_id = v_rg23_part_ii_no)

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

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,
852: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
853: WHERE register_id = v_rg23_part_ii_no)