APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_PLA_TRXS_S1

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

835: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
836: WHERE register_id = v_rg23_part_ii_no)
837: WHERE register_id = v_rg23_part_i_no;
838: ELSIF l_rec.payment_register IN( 'PLA') THEN
839: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
840: UPDATE JAI_CMN_RG_I_TRXS
841: SET register_id_part_ii = v_pla_register_no,
842: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
843: WHERE register_id = v_pla_register_no)

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

852: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
853: WHERE register_id = v_rg23_part_ii_no)
854: WHERE register_id = v_rg23_part_i_no;
855: ELSIF l_rec.payment_register IN( 'PLA') THEN
856: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
857: UPDATE JAI_CMN_RG_23AC_I_TRXS
858: SET REGISTER_ID_PART_II = v_pla_register_no,
859: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
860: WHERE register_id = v_pla_register_no)