APPS.JAI_MTL_TRXS_PKG dependencies on DUAL

Line 872: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;

868: END IF;
869: IF nvl(ln_cess_amount,0)<>0 THEN
870: /*
871: BEGIN
872: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
873: EXCEPTION when others THEN
874: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
875: END;
876: *//*commented the above by vkaranam for bug #5907436*/

Line 874: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;

870: /*
871: BEGIN
872: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
873: EXCEPTION when others THEN
874: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
875: END;
876: *//*commented the above by vkaranam for bug #5907436*/
877: BEGIN
878: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';

Line 5015: select jai_rcv_rgm_claims_s.NEXTVAL into ln_claim_schedule_id from dual;

5011:
5012:
5013: for sch_det in cur_get_schedule(ln_schedule_id)
5014: loop
5015: select jai_rcv_rgm_claims_s.NEXTVAL into ln_claim_schedule_id from dual;
5016: INSERT
5017: INTO jai_rcv_rgm_claims
5018: (
5019: CLAIM_SCHEDULE_ID,