APPS.OKS_ARFEEDER_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 1080: okc_k_party_roles_b party

1076: Cursor l_Salesrep_csr(p_code IN VARCHAR2,
1077: p_dnz_chr_id IN NUMBER) Is
1078: SELECT contact.object1_id1
1079: FROM okc_contacts contact,
1080: okc_k_party_roles_b party
1081: WHERE contact.cpl_id = party.id --p_cpl_id
1082: AND contact.cro_code = p_code
1083: AND party.rle_code in ('VENDOR','MERCHANT')
1084: AND party.dnz_chr_id = p_dnz_chr_id

Line 1307: ,Okc_k_party_roles_B Party

1303:
1304: Cursor Contact_csr( p_hdr_id NUMBER, p_cle_id NUMBER) Is
1305: SELECT Contact.object1_id1 , Contact.cro_code
1306: FROM Okc_contacts Contact
1307: ,Okc_k_party_roles_B Party
1308: WHERE Contact.cpl_id = Party.id
1309: AND Contact.cro_code in ('CUST_BILLING','CUST_SHIPPING')
1310: AND p_date_billed_from between nvl(contact.start_date,p_date_billed_From) and
1311: nvl(contact.end_date,p_date_billed_from)