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.12010000.2 2009/07/17 23:27:43 sechawla ship $ */
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 580: FROM okc_k_party_roles_b cplb

576: p_cpl_id IN NUMBER) IS
577:
578: CURSOR l_cpl_csr (p_cpl_id in number) IS
579: SELECT 'Y'
580: FROM okc_k_party_roles_b cplb
581: WHERE cplb.id = p_cpl_id;
582:
583: l_exists varchar2(1) default 'N';
584:

Line 1286: okc_k_party_roles_b cplb

1282: p_vendor_id IN NUMBER) is
1283: SELECT 'Y'
1284: FROM po_vendor_sites_all pvs,
1285: okc_k_headers_b chrb,
1286: okc_k_party_roles_b cplb
1287: WHERE pvs.vendor_id = p_vendor_id
1288: AND pvs.org_id = chrb.authoring_org_id
1289: AND pvs.vendor_site_id = p_paysite_id
1290: AND nvl(pvs.pay_site_flag,'N') = 'Y'

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

3830: ,LAST_UPDATE_DATE
3831: ,LAST_UPDATE_LOGIN
3832: ,ORIG_CONTRACT_LINE_ID
3833: FROM OKL_PARTY_PAYMENT_DTLS
3834: WHERE cpl_id in (select id from okc_k_party_roles_b where dnz_chr_id = p_chr_id);
3835:
3836: RETURN l_return_status;
3837: EXCEPTION
3838: -- other appropriate handlers

Line 3955: 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;

3951: ,LAST_UPDATE_LOGIN
3952: ,ORIG_CONTRACT_LINE_ID
3953:
3954: FROM OKL_PARTY_PYMT_DTLS_H
3955: 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;
3956:
3957:
3958: RETURN l_return_status;
3959: EXCEPTION