APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 2527: okl_party_payment_dtls pyd

2523: pyd.PROCESSING_FEE_FIXED_AMOUNT,
2524: pyd.PROCESSING_FEE_PERCENT,
2525: pyd.PAYMENT_BASIS
2526: FROM okc_k_party_roles_b party,
2527: okl_party_payment_dtls pyd
2528: WHERE party.dnz_chr_id = p_chr_id
2529: AND party.rle_code = 'OKL_VENDOR'
2530: AND party.cle_id IS NULL
2531: AND party.id = pyd.cpl_id (+);

Line 2536: from okl_party_payment_dtls

2532:
2533: CURSOR rbk_evg_dtl_csr (p_pmnt_hdr_id NUMBER,
2534: p_vendor_id NUMBER) IS
2535: select *
2536: from okl_party_payment_dtls
2537: where payment_hdr_id = p_pmnt_hdr_id
2538: and vendor_id = p_vendor_id;
2539:
2540: rbk_evg_dtl_rec rbk_evg_dtl_csr%ROWTYPE;

Line 3007: FROM okl_party_payment_dtls dtl,

3003: p_cpl_id NUMBER) IS
3004: SELECT hdr.id hdr_id,
3005: hdr.passthru_term,
3006: dtl.*
3007: FROM okl_party_payment_dtls dtl,
3008: okl_party_payment_hdr hdr
3009: WHERE cpl_id = p_cpl_id
3010: AND cle_id = p_cle_id
3011: AND hdr.id = dtl.payment_hdr_id;

Line 3017: FROM okl_party_payment_dtls dtl,

3013: CURSOR orig_pth_detail_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,
3014: p_cle_id NUMBER,
3015: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
3016: SELECT dtl.*
3017: FROM okl_party_payment_dtls dtl,
3018: okl_party_payment_hdr hdr
3019: WHERE vendor_id = p_vendor_id
3020: AND cle_id = p_cle_id
3021: AND hdr.passthru_term = p_term