APPS.JAI_AR_IMPORT_POPU_PKG dependencies on DUAL

Line 64: from dual;

60: );
61:
62: cursor c_ont_source_code is
63: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
64: from dual;
65:
66: CURSOR JA_SO_TAX_LINES_INFO IS
67: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount,A.tax_amount,
68: A.func_tax_amount,

Line 4179: SELECT JAI_CMN_RG_23AC_I_TRXS_S.currval INTO v_part_i_register_id FROM dual; /* txns changed to trxs by rchandan for bug#4487676 */

4175: v_last_updated_by ,
4176: v_last_update_login
4177: );
4178:
4179: SELECT JAI_CMN_RG_23AC_I_TRXS_S.currval INTO v_part_i_register_id FROM dual; /* txns changed to trxs by rchandan for bug#4487676 */
4180:
4181: jai_om_rg_pkg.ja_in_rg23_part_II_entry(
4182: v_reg_code ,
4183: v_reg_type ,

Line 4210: 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 */

4206: null ,
4207: null
4208: );
4209:
4210: 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 */
4211:
4212: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
4213:
4214: UPDATE JAI_CMN_RG_23AC_I_TRXS

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

4208: );
4209:
4210: 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 */
4211:
4212: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
4213:
4214: UPDATE JAI_CMN_RG_23AC_I_TRXS
4215: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
4216: charge_account_id = (

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 4464: from dual;

4460: v_ato_line_id Varchar2(30);
4461:
4462: cursor c_ont_source_code is
4463: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
4464: from dual;
4465: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
4466:
4467:
4468: ln_bill_only number; --File.Sql.35 Cbabu := 0;

Line 4925: from dual;

4921:
4922:
4923: cursor c_ont_source_code is
4924: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
4925: from dual;
4926: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
4927:
4928: CURSOR cur_get_transaction_type_id
4929: IS