APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on OKL_CURE_REFUNDS_DTLS_UV

Line 675: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;

671:
672: TYPE c_getcontractsCurTyp IS REF CURSOR;
673: c_getcontracts c_getcontractsCurTyp; -- declare cursor variable
674:
675: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;
676: l_contract_number okl_cure_refunds_dtls_uv.contract_number%TYPE;
677: l_idx INTEGER;
678: l_amount_past_due NUMBER;
679: BEGIN

Line 676: l_contract_number okl_cure_refunds_dtls_uv.contract_number%TYPE;

672: TYPE c_getcontractsCurTyp IS REF CURSOR;
673: c_getcontracts c_getcontractsCurTyp; -- declare cursor variable
674:
675: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;
676: l_contract_number okl_cure_refunds_dtls_uv.contract_number%TYPE;
677: l_idx INTEGER;
678: l_amount_past_due NUMBER;
679: BEGIN
680:

Line 881: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;

877:
878: TYPE c_getcontractsCurTyp IS REF CURSOR;
879: c_getcontracts c_getcontractsCurTyp; -- declare cursor variable
880:
881: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;
882: l_refund_amount_due okl_cure_refunds_dtls_uv.refund_amount_due%TYPE;
883:
884: BEGIN
885: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 882: l_refund_amount_due okl_cure_refunds_dtls_uv.refund_amount_due%TYPE;

878: TYPE c_getcontractsCurTyp IS REF CURSOR;
879: c_getcontracts c_getcontractsCurTyp; -- declare cursor variable
880:
881: l_contract_id okl_cure_refunds_dtls_uv.contract_id%TYPE;
882: l_refund_amount_due okl_cure_refunds_dtls_uv.refund_amount_due%TYPE;
883:
884: BEGIN
885: IF (G_DEBUG_ENABLED = 'Y') THEN
886: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

Line 898: from okl_cure_refunds_dtls_uv

894: IF p_pay_cure_refunds_rec.REFUND_TYPE ='VENDOR_SITE' THEN
895: OPEN c_getcontracts
896: FOR
897: select contract_id,refund_amount_due
898: from okl_cure_refunds_dtls_uv
899: where vendor_site_id =p_pay_cure_refunds_rec.vendor_site_id and
900: contract_currency_code =p_pay_cure_refunds_rec.currency;
901:
902: elsif p_pay_cure_refunds_rec.REFUND_TYPE ='ACROSS_SITES' THEN

Line 906: from okl_cure_refunds_dtls_uv

902: elsif p_pay_cure_refunds_rec.REFUND_TYPE ='ACROSS_SITES' THEN
903: OPEN c_getcontracts
904: FOR
905: select contract_id,refund_amount_due
906: from okl_cure_refunds_dtls_uv
907: where vendor_id =p_pay_cure_refunds_rec.vendor_id and
908: contract_currency_code =p_pay_cure_refunds_rec.currency;
909:
910: