APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 876: registers i.e either of JAI_CMN_RG_23AC_II_TRXS or JAI_CMN_RG_PLA_TRXS was bypassed if the first one was found to contain

872:
873: Reason: -
874: ======
875: This was happening as the code that calls the jai_om_rg_pkg package to insert records into any of the amount
876: registers i.e either of JAI_CMN_RG_23AC_II_TRXS or JAI_CMN_RG_PLA_TRXS was bypassed if the first one was found to contain
877: a 'CT3' type of exemption.
878:
879: Fix :-
880: ======

Line 2158: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;

2154: WHERE
2155: register_id = v_rg23_part_i_no;
2156: ELSIF v_reg_type IN( 'PLA') THEN
2157: lv_statement_no := '38';
2158: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2159: lv_statement_no := '39';
2160: UPDATE
2161: JAI_CMN_RG_I_TRXS
2162: SET

Line 2167: JAI_CMN_RG_PLA_TRXS

2163: register_id_part_ii = v_pla_register_no,
2164: charge_account_id = (
2165: SELECT CHARGE_ACCOUNT_ID
2166: FROM
2167: JAI_CMN_RG_PLA_TRXS
2168: WHERE
2169: register_id = v_pla_register_no
2170: )
2171: WHERE

Line 2191: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;

2187: WHERE register_id = v_rg23_part_ii_no)
2188: WHERE register_id = v_rg23_part_i_no;
2189: ELSIF v_reg_type IN( 'PLA') THEN
2190: lv_statement_no := '43';
2191: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2192: lv_statement_no := '44';
2193: UPDATE
2194: JAI_CMN_RG_23AC_I_TRXS
2195: SET

Line 2200: FROM JAI_CMN_RG_PLA_TRXS

2196: REGISTER_ID_PART_II = v_pla_register_no,
2197: charge_account_id = (
2198: SELECT
2199: charge_account_id
2200: FROM JAI_CMN_RG_PLA_TRXS
2201: WHERE
2202: register_id = v_pla_register_no
2203: )
2204: WHERE register_id = v_rg23_part_i_no;