DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 30: from okl_party_payment_hdr

26: subtype ppydv_tbl_type is OKL_PYD_PVT.ppydv_tbl_type;
27:
28: CURSOR party_payment_csr(p_dnz_chr_id NUMBER, p_cle_id NUMBER, p_passthru_term VARCHAR2) IS
29: select id, passthru_term
30: from okl_party_payment_hdr
31: where
32: dnz_chr_id = p_dnz_chr_id and cle_id = p_cle_id and
33: passthru_term = p_passthru_term;
34: party_payment_rec party_payment_csr%ROWTYPE;

Line 471: FROM okl_party_payment_hdr

467: -- basis from original contract
468: CURSOR l_old_passthru_csr(p_cle_id IN NUMBER,
469: p_passthru_term in VARCHAR2) IS
470: SELECT payout_basis
471: FROM okl_party_payment_hdr
472: WHERE cle_id = p_cle_id
473: AND passthru_term = p_passthru_term;
474:
475: CURSOR l_cle_csr(p_cle_id IN NUMBER) IS