DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 3454: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;

3450: );
3451:
3452: SELECT JAI_CMN_RG_23AC_I_TRXS_S.currval INTO v_rg23_part_i_no FROM dual; /* txns changed to trxs by rchandan for bug# bug#4487676 */
3453:
3454: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
3455:
3456: UPDATE JAI_CMN_RG_23AC_I_TRXS
3457: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
3458: charge_account_id = (

Line 3462: JAI_CMN_RG_23AC_II_TRXS

3458: charge_account_id = (
3459: SELECT
3460: charge_account_id
3461: FROM
3462: JAI_CMN_RG_23AC_II_TRXS
3463: WHERE
3464: register_id = v_rg23_part_ii_no
3465: )
3466: WHERE register_id = v_rg23_part_i_no;