DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 3755: SELECT JAI_CMN_RG_PLA_TRXS_S1.currval INTO v_pla_register_no FROM dual;

3751: v_last_update_login
3752: );
3753:
3754:
3755: SELECT JAI_CMN_RG_PLA_TRXS_S1.currval INTO v_pla_register_no FROM dual;
3756: UPDATE JAI_CMN_RG_23AC_I_TRXS
3757: SET REGISTER_ID_PART_II = v_pla_register_no,
3758: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS
3759: WHERE register_id = v_pla_register_no)

Line 3758: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS

3754:
3755: SELECT JAI_CMN_RG_PLA_TRXS_S1.currval INTO v_pla_register_no FROM dual;
3756: UPDATE JAI_CMN_RG_23AC_I_TRXS
3757: SET REGISTER_ID_PART_II = v_pla_register_no,
3758: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS
3759: WHERE register_id = v_pla_register_no)
3760: WHERE register_id = v_rg23_part_i_no;
3761: END IF;
3762: