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.

[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_PARTY_PAYMENT_HDR

Line 3272: FROM okl_party_payment_hdr

3268: --1. If evg hdr is defined, vendor params detail is required
3269: --Find out whether contract evg hdr is existing --
3270: CURSOR evg_hdr_csr (p_chr_id IN NUMBER) IS
3271: SELECT '1'
3272: FROM okl_party_payment_hdr
3273: WHERE dnz_chr_id = p_chr_id
3274: AND cle_id IS NULL;
3275:
3276: l_evg_hdr_exist VARCHAR2(1);

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 3308: p_term IN okl_party_payment_hdr.PASSTHRU_TERM%TYPE) IS

3304: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
3305:
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

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 3338: FROM okl_party_payment_hdr vHdr,

3334: vDtls.PROCESSING_FEE_PERCENT,
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

Line 3355: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;

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
3359: CURSOR payout_basis_csr (p_chr_id IN NUMBER,p_cle_id IN NUMBER )IS

Line 3356: l_passthru_term okl_party_payment_hdr.passthru_term%TYPE;

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
3359: CURSOR payout_basis_csr (p_chr_id IN NUMBER,p_cle_id IN NUMBER )IS
3360: SELECT pph.passthru_term, pph.payout_basis

Line 3361: FROM okl_party_payment_hdr pph

3357:
3358: --Found out payout basis
3359: CURSOR payout_basis_csr (p_chr_id IN NUMBER,p_cle_id IN NUMBER )IS
3360: SELECT pph.passthru_term, pph.payout_basis
3361: FROM okl_party_payment_hdr pph
3362: WHERE pph.dnz_chr_id = p_chr_id
3363: AND pph.cle_id = p_cle_id;
3364:
3365: --Find out the payment info for contract line

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 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 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 3457: okl_party_payment_hdr pph

3453: pph.passthru_stream_type_id
3454: FROM okl_k_lines_full_v line,
3455: okc_line_styles_v style,
3456: okc_statuses_v sts,
3457: okl_party_payment_hdr pph
3458: WHERE line.lse_id = style.id
3459: AND line.sts_code = sts.code
3460: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
3461: AND style.lty_code IN ('SOLD_SERVICE','FEE','FREE_FORM1')

Line 5809: FROM okl_party_payment_hdr pph

5805:
5806: CURSOR pth_hdr_csr(p_chr_id IN NUMBER,
5807: p_cle_id IN NUMBER) IS
5808: SELECT 1
5809: FROM okl_party_payment_hdr pph
5810: WHERE cle_id = p_cle_id
5811: AND dnz_chr_id = p_chr_id
5812: AND passthru_term = 'BASE';
5813:

Line 8210: FROM okl_party_payment_hdr pph

8206: --------------
8207: CURSOR pth_hdr_csr(p_chr_id IN NUMBER,
8208: p_cle_id IN NUMBER) IS
8209: SELECT 1
8210: FROM okl_party_payment_hdr pph
8211: WHERE cle_id = p_cle_id
8212: AND dnz_chr_id = p_chr_id;
8213:
8214: l_pth_present VARCHAR2(1);

Line 8221: FROM okl_party_payment_hdr pph,

8217: p_cle_id IN NUMBER) IS
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;