eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_PARTY_PAYMENT_HDR

Line 3115: FROM okl_party_payment_hdr

3111: --1. If evg hdr is defined, vendor params detail is required
3112: --Find out whether contract evg hdr is existing --
3113: CURSOR evg_hdr_csr (p_chr_id IN NUMBER) IS
3114: SELECT '1'
3115: FROM okl_party_payment_hdr
3116: WHERE dnz_chr_id = p_chr_id
3117: AND cle_id IS NULL;
3118:
3119: l_evg_hdr_exist VARCHAR2(1);

Line 3132: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3128:
3129: -- Find out whether vendor evg pt params exists
3130: CURSOR evg_dtls_csr (p_vendor_id IN NUMBER, p_chr_id IN NUMBER) IS
3131: SELECT '1'
3132: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3133: WHERE ppy.vendor_id = p_vendor_id
3134: AND ppy.payment_hdr_id = pph.id
3135: AND pph.dnz_chr_id = p_chr_id
3136: AND pph.cle_id IS NULL;

Line 3151: p_term IN okl_party_payment_hdr.PASSTHRU_TERM%TYPE) IS

3147: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
3148:
3149: -- Find out the disb fixed amt for each line for all vendors--
3150: CURSOR disb_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER,
3151: p_term IN okl_party_payment_hdr.PASSTHRU_TERM%TYPE) IS
3152: SELECT SUM(ppy.disbursement_fixed_amount)
3153: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3154: WHERE pph.dnz_chr_id = p_chr_id
3155: AND NVL(pph.cle_id, -9999) = p_cle_id

Line 3153: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3149: -- Find out the disb fixed amt for each line for all vendors--
3150: CURSOR disb_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER,
3151: p_term IN okl_party_payment_hdr.PASSTHRU_TERM%TYPE) IS
3152: SELECT SUM(ppy.disbursement_fixed_amount)
3153: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3154: WHERE pph.dnz_chr_id = p_chr_id
3155: AND NVL(pph.cle_id, -9999) = p_cle_id
3156: AND pph.id = ppy.payment_hdr_id
3157: AND pph.passthru_term = p_term

Line 3163: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3159:
3160: -- Find out the disb fixed amt for all vendors on the contract--
3161: CURSOR disb_amt_csr1 (p_chr_id IN NUMBER) IS
3162: SELECT SUM(ppy.disbursement_fixed_amount), pph.passthru_term, pph.payout_basis
3163: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3164: WHERE pph.dnz_chr_id = p_chr_id
3165: AND pph.cle_id IS NULL
3166: AND pph.id = ppy.payment_hdr_id
3167: GROUP BY ppy.payment_hdr_id,pph.passthru_term, pph.payout_basis;

Line 3170: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;

3166: AND pph.id = ppy.payment_hdr_id
3167: GROUP BY ppy.payment_hdr_id,pph.passthru_term, pph.payout_basis;
3168:
3169: l_fixed_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;
3170: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
3171: l_passthru_term okl_party_payment_hdr.passthru_term%TYPE;
3172:
3173: --Found out payout basis
3174: CURSOR payout_basis_csr (p_chr_id IN NUMBER,p_cle_id IN NUMBER )IS

Line 3171: l_passthru_term okl_party_payment_hdr.passthru_term%TYPE;

3167: GROUP BY ppy.payment_hdr_id,pph.passthru_term, pph.payout_basis;
3168:
3169: l_fixed_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;
3170: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
3171: l_passthru_term okl_party_payment_hdr.passthru_term%TYPE;
3172:
3173: --Found out payout basis
3174: CURSOR payout_basis_csr (p_chr_id IN NUMBER,p_cle_id IN NUMBER )IS
3175: SELECT pph.passthru_term, pph.payout_basis

Line 3176: FROM okl_party_payment_hdr pph

3172:
3173: --Found out payout basis
3174: CURSOR payout_basis_csr (p_chr_id IN NUMBER,p_cle_id IN NUMBER )IS
3175: SELECT pph.passthru_term, pph.payout_basis
3176: FROM okl_party_payment_hdr pph
3177: WHERE pph.dnz_chr_id = p_chr_id
3178: AND pph.cle_id = p_cle_id;
3179:
3180: --Find out the payment info for contract line

Line 3215: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph, okc_k_party_roles_b rle, po_vendors po

3211:
3212: --3. Disb basis for all vendors should be same
3213: CURSOR disb_basis_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3214: SELECT ppy.disbursement_basis, po.vendor_name
3215: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph, okc_k_party_roles_b rle, po_vendors po
3216: WHERE pph.dnz_chr_id = p_chr_id
3217: AND pph.cle_id = p_cle_id
3218: AND pph.id = ppy.payment_hdr_id
3219: AND ppy.cpl_id = rle.id

Line 3228: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3224:
3225: --4. Total process fee fixed amt not exceed line amt
3226: CURSOR proc_fee_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3227: SELECT SUM(ppy.processing_fee_fixed_amount)
3228: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3229: WHERE pph.dnz_chr_id = p_chr_id
3230: AND pph.cle_id = p_cle_id
3231: AND pph.id = ppy.payment_hdr_id;
3232:

Line 3237: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3233: l_proc_fee_amt okl_party_payment_dtls.processing_fee_fixed_amount%TYPE;
3234:
3235: CURSOR pth_amount_csr(p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3236: SELECT SUM(ppy.disbursement_fixed_amount)
3237: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3238: WHERE pph.dnz_chr_id = p_chr_id
3239: AND pph.cle_id = p_cle_id
3240: AND pph.id = ppy.payment_hdr_id;
3241:

Line 3272: okl_party_payment_hdr pph

3268: pph.passthru_stream_type_id
3269: FROM okl_k_lines_full_v line,
3270: okc_line_styles_v style,
3271: okc_statuses_v sts,
3272: okl_party_payment_hdr pph
3273: WHERE line.lse_id = style.id
3274: AND line.sts_code = sts.code
3275: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
3276: AND style.lty_code IN ('SOLD_SERVICE','FEE','FREE_FORM1')

Line 5422: FROM okl_party_payment_hdr pph

5418:
5419: CURSOR pth_hdr_csr(p_chr_id IN NUMBER,
5420: p_cle_id IN NUMBER) IS
5421: SELECT 1
5422: FROM okl_party_payment_hdr pph
5423: WHERE cle_id = p_cle_id
5424: AND dnz_chr_id = p_chr_id
5425: AND passthru_term = 'BASE';
5426:

Line 7793: FROM okl_party_payment_hdr pph

7789: --------------
7790: CURSOR pth_hdr_csr(p_chr_id IN NUMBER,
7791: p_cle_id IN NUMBER) IS
7792: SELECT 1
7793: FROM okl_party_payment_hdr pph
7794: WHERE cle_id = p_cle_id
7795: AND dnz_chr_id = p_chr_id;
7796:
7797: l_pth_present VARCHAR2(1);

Line 7804: FROM okl_party_payment_hdr pph,

7800: p_cle_id IN NUMBER) IS
7801: SELECT ppd.vendor_id,
7802: ppd.pay_site_id,
7803: pph.passthru_term
7804: FROM okl_party_payment_hdr pph,
7805: okl_party_payment_dtls ppd
7806: WHERE pph.cle_id = p_cle_id
7807: AND pph.dnz_chr_id = p_chr_id
7808: AND ppd.payment_hdr_id = pph.id;