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_DTLS

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 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 3169: l_fixed_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;

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;
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

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 3223: l_disb_basis okl_party_payment_dtls.disbursement_basis%TYPE;

3219: AND ppy.cpl_id = rle.id
3220: AND rle.rle_code = 'OKL_VENDOR'
3221: AND rle.object1_id1 = po.vendor_id;
3222:
3223: l_disb_basis okl_party_payment_dtls.disbursement_basis%TYPE;
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)

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 3233: l_proc_fee_amt okl_party_payment_dtls.processing_fee_fixed_amount%TYPE;

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:
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

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 3242: l_pth_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;

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:
3242: l_pth_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;
3243:
3244: --Bug 4917691 fmiao end ------------------------------------
3245:
3246:

Line 3287: FROM okl_party_payment_dtls

3283: disbursement_fixed_amount,
3284: disbursement_percent,
3285: payment_start_date,
3286: vendor_id
3287: FROM okl_party_payment_dtls
3288: WHERE payment_hdr_id = p_payment_hdr_id;
3289:
3290: CURSOR vendor_csr(p_vendor_id IN NUMBER) IS
3291: SELECT vendor_name

Line 7805: okl_party_payment_dtls ppd

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;
7809:

Line 11167: FROM okl_party_payment_dtls pyd,

11163: recourse_yn VARCHAR2(1);
11164:
11165: CURSOR check_refund_details(p_subsidy_cle_id NUMBER) IS
11166: SELECT pyd.vendor_id
11167: FROM okl_party_payment_dtls pyd,
11168: okc_k_party_roles_b cplb,
11169: okc_k_lines_b cleb
11170: WHERE pyd.cpl_id = cplb.id
11171: AND cplb.cle_id = cleb.id