APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_PARTY_PAYMENT_DTLS

Line 3289: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3285:
3286: -- Find out whether vendor evg pt params exists
3287: CURSOR evg_dtls_csr (p_vendor_id IN NUMBER, p_chr_id IN NUMBER) IS
3288: SELECT '1'
3289: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3290: WHERE ppy.vendor_id = p_vendor_id
3291: AND ppy.payment_hdr_id = pph.id
3292: AND pph.dnz_chr_id = p_chr_id
3293: AND pph.cle_id IS NULL;

Line 3310: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3306: -- Find out the disb fixed amt for each line for all vendors--
3307: CURSOR disb_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER,
3308: p_term IN okl_party_payment_hdr.PASSTHRU_TERM%TYPE) IS
3309: SELECT SUM(ppy.disbursement_fixed_amount)
3310: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3311: WHERE pph.dnz_chr_id = p_chr_id
3312: AND NVL(pph.cle_id, -9999) = p_cle_id
3313: AND pph.id = ppy.payment_hdr_id
3314: AND pph.passthru_term = p_term

Line 3320: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3316:
3317: -- Find out the disb fixed amt for all vendors on the contract--
3318: CURSOR disb_amt_csr1 (p_chr_id IN NUMBER) IS
3319: SELECT SUM(ppy.disbursement_fixed_amount), pph.passthru_term, pph.payout_basis
3320: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3321: WHERE pph.dnz_chr_id = p_chr_id
3322: AND pph.cle_id IS NULL
3323: AND pph.id = ppy.payment_hdr_id
3324: GROUP BY ppy.payment_hdr_id,pph.passthru_term, pph.payout_basis;

Line 3339: okl_party_payment_dtls vDtls,

3335: vDtls.PAYMENT_START_DATE,
3336: vDtls.PAYMENT_FREQUENCY,
3337: chr.END_DATE CONTRACT_END_DATE
3338: FROM okl_party_payment_hdr vHdr,
3339: okl_party_payment_dtls vDtls,
3340: okc_k_headers_b chr
3341: WHERE vDtls.payment_hdr_id = vHdr.id
3342: AND vHdr.CLE_ID = cleId
3343: AND vHdr.DNZ_CHR_ID = khrId

Line 3354: l_fixed_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;

3350: SELECT CEIL(Months_between(p_contract_end_date, p_payout_date)/
3351: DECODE(p_frequency,'A',12,'S',6,'Q',3,1))
3352: FROM DUAL;
3353:
3354: l_fixed_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;
3355: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
3356: l_passthru_term okl_party_payment_hdr.passthru_term%TYPE;
3357:
3358: --Found out payout basis

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

3396:
3397: --3. Disb basis for all vendors should be same
3398: CURSOR disb_basis_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3399: SELECT ppy.disbursement_basis, po.vendor_name
3400: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph, okc_k_party_roles_b rle, po_vendors po
3401: WHERE pph.dnz_chr_id = p_chr_id
3402: AND pph.cle_id = p_cle_id
3403: AND pph.id = ppy.payment_hdr_id
3404: AND ppy.cpl_id = rle.id

Line 3408: l_disb_basis okl_party_payment_dtls.disbursement_basis%TYPE;

3404: AND ppy.cpl_id = rle.id
3405: AND rle.rle_code = 'OKL_VENDOR'
3406: AND rle.object1_id1 = po.vendor_id;
3407:
3408: l_disb_basis okl_party_payment_dtls.disbursement_basis%TYPE;
3409:
3410: --4. Total process fee fixed amt not exceed line amt
3411: CURSOR proc_fee_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3412: SELECT SUM(ppy.processing_fee_fixed_amount)

Line 3413: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3409:
3410: --4. Total process fee fixed amt not exceed line amt
3411: CURSOR proc_fee_amt_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3412: SELECT SUM(ppy.processing_fee_fixed_amount)
3413: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3414: WHERE pph.dnz_chr_id = p_chr_id
3415: AND pph.cle_id = p_cle_id
3416: AND pph.id = ppy.payment_hdr_id;
3417:

Line 3418: l_proc_fee_amt okl_party_payment_dtls.processing_fee_fixed_amount%TYPE;

3414: WHERE pph.dnz_chr_id = p_chr_id
3415: AND pph.cle_id = p_cle_id
3416: AND pph.id = ppy.payment_hdr_id;
3417:
3418: l_proc_fee_amt okl_party_payment_dtls.processing_fee_fixed_amount%TYPE;
3419:
3420: CURSOR pth_amount_csr(p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3421: SELECT SUM(ppy.disbursement_fixed_amount)
3422: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

Line 3422: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

3418: l_proc_fee_amt okl_party_payment_dtls.processing_fee_fixed_amount%TYPE;
3419:
3420: CURSOR pth_amount_csr(p_chr_id IN NUMBER, p_cle_id IN NUMBER) IS
3421: SELECT SUM(ppy.disbursement_fixed_amount)
3422: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
3423: WHERE pph.dnz_chr_id = p_chr_id
3424: AND pph.cle_id = p_cle_id
3425: AND pph.id = ppy.payment_hdr_id;
3426:

Line 3427: l_pth_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;

3423: WHERE pph.dnz_chr_id = p_chr_id
3424: AND pph.cle_id = p_cle_id
3425: AND pph.id = ppy.payment_hdr_id;
3426:
3427: l_pth_amt okl_party_payment_dtls.disbursement_fixed_amount%TYPE;
3428:
3429: --Bug 4917691 fmiao end ------------------------------------
3430:
3431:

Line 3472: FROM okl_party_payment_dtls

3468: disbursement_fixed_amount,
3469: disbursement_percent,
3470: payment_start_date,
3471: vendor_id
3472: FROM okl_party_payment_dtls
3473: WHERE payment_hdr_id = p_payment_hdr_id;
3474:
3475: CURSOR vendor_csr(p_vendor_id IN NUMBER) IS
3476: SELECT vendor_name

Line 8222: okl_party_payment_dtls ppd

8218: SELECT ppd.vendor_id,
8219: ppd.pay_site_id,
8220: pph.passthru_term
8221: FROM okl_party_payment_hdr pph,
8222: okl_party_payment_dtls ppd
8223: WHERE pph.cle_id = p_cle_id
8224: AND pph.dnz_chr_id = p_chr_id
8225: AND ppd.payment_hdr_id = pph.id;
8226:

Line 11590: FROM okl_party_payment_dtls pyd,

11586: recourse_yn VARCHAR2(1);
11587:
11588: CURSOR check_refund_details(p_subsidy_cle_id NUMBER) IS
11589: SELECT pyd.vendor_id
11590: FROM okl_party_payment_dtls pyd,
11591: okc_k_party_roles_b cplb,
11592: okc_k_lines_b cleb
11593: WHERE pyd.cpl_id = cplb.id
11594: AND cplb.cle_id = cleb.id