APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_PLA_TRXS_S1

Line 945: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

941: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
942: WHERE register_id = v_rg23_part_ii_no)
943: WHERE register_id = v_rg23_part_i_no;
944: ELSIF l_rec.payment_register IN( 'PLA') THEN
945: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
946: UPDATE JAI_CMN_RG_I_TRXS
947: SET register_id_part_ii = v_pla_register_no,
948: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
949: WHERE register_id = v_pla_register_no)

Line 962: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

958: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
959: WHERE register_id = v_rg23_part_ii_no)
960: WHERE register_id = v_rg23_part_i_no;
961: ELSIF l_rec.payment_register IN( 'PLA') THEN
962: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
963: UPDATE JAI_CMN_RG_23AC_I_TRXS
964: SET REGISTER_ID_PART_II = v_pla_register_no,
965: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
966: WHERE register_id = v_pla_register_no)