APPS.JAI_MTL_TRXS_PKG dependencies on DUAL

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

745: END IF;
746: IF nvl(ln_cess_amount,0)<>0 THEN
747: /*
748: BEGIN
749: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
750: EXCEPTION when others THEN
751: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
752: END;
753: *//*commented the above by vkaranam for bug #5907436*/

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

747: /*
748: BEGIN
749: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
750: EXCEPTION when others THEN
751: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
752: END;
753: *//*commented the above by vkaranam for bug #5907436*/
754: BEGIN
755: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';

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

4568:
4569:
4570: for sch_det in cur_get_schedule(ln_schedule_id)
4571: loop
4572: select jai_rcv_rgm_claims_s.NEXTVAL into ln_claim_schedule_id from dual;
4573: INSERT
4574: INTO jai_rcv_rgm_claims
4575: (
4576: CLAIM_SCHEDULE_ID,