APPS.OKL_PYD_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 6: FROM okc_k_party_roles_b WHERE

2: /* $Header: OKLSPYDB.pls 120.4 2005/09/23 12:22:49 varangan noship $ */
3:
4: CURSOR party_cur(p_cpl_id IN NUMBER) IS
5: SELECT dnz_chr_id
6: FROM okc_k_party_roles_b WHERE
7: id = p_cpl_id;
8: party_rec party_cur%ROWTYPE;
9:
10: ---------------------------------------------------------------------------

Line 570: FROM okc_k_party_roles_b cplb

566: p_cpl_id IN NUMBER) IS
567:
568: CURSOR l_cpl_csr (p_cpl_id in number) IS
569: SELECT 'Y'
570: FROM okc_k_party_roles_b cplb
571: WHERE cplb.id = p_cpl_id;
572:
573: l_exists varchar2(1) default 'N';
574:

Line 1276: okc_k_party_roles_b cplb

1272: p_vendor_id IN NUMBER) is
1273: SELECT 'Y'
1274: FROM po_vendor_sites_all pvs,
1275: okc_k_headers_b chrb,
1276: okc_k_party_roles_b cplb
1277: WHERE pvs.vendor_id = p_vendor_id
1278: AND pvs.org_id = chrb.authoring_org_id
1279: AND pvs.vendor_site_id = p_paysite_id
1280: AND nvl(pvs.pay_site_flag,'N') = 'Y'

Line 3803: WHERE cpl_id in (select id from okc_k_party_roles_b where dnz_chr_id = p_chr_id);

3799: ,LAST_UPDATED_BY
3800: ,LAST_UPDATE_DATE
3801: ,LAST_UPDATE_LOGIN
3802: FROM OKL_PARTY_PAYMENT_DTLS
3803: WHERE cpl_id in (select id from okc_k_party_roles_b where dnz_chr_id = p_chr_id);
3804:
3805: RETURN l_return_status;
3806: EXCEPTION
3807: -- other appropriate handlers

Line 3922: WHERE cpl_id in (select id from okc_k_party_roles_b where dnz_chr_id = p_chr_id) and major_version = p_major_version;

3918: ,LAST_UPDATE_DATE
3919: ,LAST_UPDATE_LOGIN
3920:
3921: FROM OKL_PARTY_PYMT_DTLS_H
3922: WHERE cpl_id in (select id from okc_k_party_roles_b where dnz_chr_id = p_chr_id) and major_version = p_major_version;
3923:
3924:
3925: RETURN l_return_status;
3926: EXCEPTION