APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 2255: okl_party_payment_dtls pyd

2251: pyd.PROCESSING_FEE_FIXED_AMOUNT,
2252: pyd.PROCESSING_FEE_PERCENT,
2253: pyd.PAYMENT_BASIS
2254: FROM okc_k_party_roles_b party,
2255: okl_party_payment_dtls pyd
2256: WHERE party.dnz_chr_id = p_chr_id
2257: AND party.rle_code = 'OKL_VENDOR'
2258: AND party.cle_id IS NULL
2259: AND party.id = pyd.cpl_id (+);

Line 2264: from okl_party_payment_dtls

2260:
2261: CURSOR rbk_evg_dtl_csr (p_pmnt_hdr_id NUMBER,
2262: p_vendor_id NUMBER) IS
2263: select *
2264: from okl_party_payment_dtls
2265: where payment_hdr_id = p_pmnt_hdr_id
2266: and vendor_id = p_vendor_id;
2267:
2268: rbk_evg_dtl_rec rbk_evg_dtl_csr%ROWTYPE;

Line 2760: FROM okl_party_payment_dtls dtl,

2756: p_cpl_id NUMBER) IS
2757: SELECT hdr.id hdr_id,
2758: hdr.passthru_term,
2759: dtl.*
2760: FROM okl_party_payment_dtls dtl,
2761: okl_party_payment_hdr hdr
2762: WHERE cpl_id = p_cpl_id
2763: AND cle_id = p_cle_id
2764: AND hdr.id = dtl.payment_hdr_id;

Line 2770: FROM okl_party_payment_dtls dtl,

2766: CURSOR orig_pth_detail_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,
2767: p_cle_id NUMBER,
2768: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
2769: SELECT dtl.*
2770: FROM okl_party_payment_dtls dtl,
2771: okl_party_payment_hdr hdr
2772: WHERE vendor_id = p_vendor_id
2773: AND cle_id = p_cle_id
2774: AND hdr.passthru_term = p_term