DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_PLA_TRXS_S1

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 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