APPS.OKS_ARFEEDER_PUB dependencies on OKC_CONTACTS

Line 1065: FROM okc_contacts contact,

1061: IS
1062: Cursor l_Salesrep_csr(p_code IN VARCHAR2,
1063: p_dnz_chr_id IN NUMBER) Is
1064: SELECT contact.object1_id1
1065: FROM okc_contacts contact,
1066: okc_k_party_roles_b party
1067: WHERE contact.cpl_id = party.id --p_cpl_id
1068: AND contact.cro_code = p_code
1069: AND party.rle_code in ('VENDOR','MERCHANT')

Line 1292: FROM Okc_contacts Contact

1288: AND cle_id Is Null;
1289:
1290: Cursor Contact_csr( p_hdr_id NUMBER, p_cle_id NUMBER) Is
1291: SELECT Contact.object1_id1 , Contact.cro_code
1292: FROM Okc_contacts Contact
1293: ,Okc_k_party_roles_B Party
1294: WHERE Contact.cpl_id = Party.id
1295: AND Contact.cro_code in ('CUST_BILLING','CUST_SHIPPING')
1296: AND p_date_billed_from between nvl(contact.start_date,p_date_billed_From) and