APPS.OKL_DEAL_TERMS_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 1041: from OKL_PARTY_PAYMENT_DTLS

1037: l_ppyh_found VARCHAR2(1) := 'N';
1038:
1039: Cursor l_ppyl_csr (p_ppyh_id in number) is
1040: SELECT id, cpl_id
1041: from OKL_PARTY_PAYMENT_DTLS
1042: where payment_hdr_id = p_ppyh_id;
1043:
1044: l_ppyl_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE := NULL;
1045: l_cpl_id OKL_PARTY_PAYMENT_DTLS.CPL_ID%TYPE := NULL;

Line 1044: l_ppyl_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE := NULL;

1040: SELECT id, cpl_id
1041: from OKL_PARTY_PAYMENT_DTLS
1042: where payment_hdr_id = p_ppyh_id;
1043:
1044: l_ppyl_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE := NULL;
1045: l_cpl_id OKL_PARTY_PAYMENT_DTLS.CPL_ID%TYPE := NULL;
1046:
1047: l_rgpv_rec okc_rule_pub.rgpv_rec_type;
1048: l_ppydv_rec okl_party_payments_pvt.ppydv_rec_type;

Line 1045: l_cpl_id OKL_PARTY_PAYMENT_DTLS.CPL_ID%TYPE := NULL;

1041: from OKL_PARTY_PAYMENT_DTLS
1042: where payment_hdr_id = p_ppyh_id;
1043:
1044: l_ppyl_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE := NULL;
1045: l_cpl_id OKL_PARTY_PAYMENT_DTLS.CPL_ID%TYPE := NULL;
1046:
1047: l_rgpv_rec okc_rule_pub.rgpv_rec_type;
1048: l_ppydv_rec okl_party_payments_pvt.ppydv_rec_type;
1049: l_pphv_rec okl_party_payments_pvt.pphv_rec_type;