DBA Data[Home] [Help]

APPS.OKL_DEAL_TERMS_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 1119: from OKL_PARTY_PAYMENT_DTLS

1115: l_ppyh_found VARCHAR2(1) := 'N';
1116:
1117: Cursor l_ppyl_csr (p_ppyh_id in number) is
1118: SELECT id, cpl_id
1119: from OKL_PARTY_PAYMENT_DTLS
1120: where payment_hdr_id = p_ppyh_id;
1121:
1122: l_ppyl_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE := NULL;
1123: l_cpl_id OKL_PARTY_PAYMENT_DTLS.CPL_ID%TYPE := NULL;

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

1118: SELECT id, cpl_id
1119: from OKL_PARTY_PAYMENT_DTLS
1120: where payment_hdr_id = p_ppyh_id;
1121:
1122: l_ppyl_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE := NULL;
1123: l_cpl_id OKL_PARTY_PAYMENT_DTLS.CPL_ID%TYPE := NULL;
1124:
1125: l_rgpv_rec okc_rule_pub.rgpv_rec_type;
1126: l_ppydv_rec okl_party_payments_pvt.ppydv_rec_type;

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

1119: from OKL_PARTY_PAYMENT_DTLS
1120: where payment_hdr_id = p_ppyh_id;
1121:
1122: l_ppyl_id OKL_PARTY_PAYMENT_DTLS.ID%TYPE := NULL;
1123: l_cpl_id OKL_PARTY_PAYMENT_DTLS.CPL_ID%TYPE := NULL;
1124:
1125: l_rgpv_rec okc_rule_pub.rgpv_rec_type;
1126: l_ppydv_rec okl_party_payments_pvt.ppydv_rec_type;
1127: l_pphv_rec okl_party_payments_pvt.pphv_rec_type;