DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS_S

Line 2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

2137:
2138: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2139: IF v_reg_type IN( 'RG23A','RG23C') THEN
2140: lv_statement_no := '36';
2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2142: lv_statement_no := '37';
2143: UPDATE
2144: JAI_CMN_RG_I_TRXS
2145: SET

Line 2181: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

2177: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2178: IF v_reg_type IN( 'RG23A','RG23C')
2179: THEN
2180: lv_statement_no := '41';
2181: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2182: lv_statement_no := '42';
2183: UPDATE JAI_CMN_RG_23AC_I_TRXS
2184: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
2185: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID