DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_CMN_RG_PLA_TRXS

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

4248: v_last_update_login
4249: );
4250:
4251:
4252: SELECT JAI_CMN_RG_PLA_TRXS_S1.currval INTO v_pla_register_no FROM dual;
4253: UPDATE JAI_CMN_RG_23AC_I_TRXS
4254: SET REGISTER_ID_PART_II = v_pla_register_no,
4255: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS
4256: WHERE register_id = v_pla_register_no)

Line 4255: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS

4251:
4252: SELECT JAI_CMN_RG_PLA_TRXS_S1.currval INTO v_pla_register_no FROM dual;
4253: UPDATE JAI_CMN_RG_23AC_I_TRXS
4254: SET REGISTER_ID_PART_II = v_pla_register_no,
4255: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS
4256: WHERE register_id = v_pla_register_no)
4257: WHERE register_id = v_rg23_part_i_no;
4258: END IF;
4259: