DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_PARTY_CONTACTS

Line 2187: FROM okc_rep_party_contacts

2183:
2184:
2185: CURSOR contact_unique_csr IS
2186: SELECT 1
2187: FROM okc_rep_party_contacts
2188: WHERE contract_id = p_contract_id
2189: AND party_id = p_party_id
2190: AND party_role_code = p_party_role_code
2191: AND contact_id = p_contact_id

Line 6149: FROM OKC_REP_PARTY_CONTACTS

6145: l_index NUMBER;
6146:
6147: CURSOR vendor_contact_csr IS
6148: SELECT contact_id
6149: FROM OKC_REP_PARTY_CONTACTS
6150: WHERE contract_id = p_document_id
6151: AND party_id = p_external_party_id
6152: AND party_role_code = G_PARTY_ROLE_SUPPLIER;
6153:

Line 6317: FROM OKC_REP_PARTY_CONTACTS

6313: l_index NUMBER;
6314:
6315: CURSOR tca_contact_csr IS
6316: SELECT contact_id
6317: FROM OKC_REP_PARTY_CONTACTS
6318: WHERE contract_id = p_document_id
6319: AND party_id = p_external_party_id
6320: AND party_role_code = p_external_party_role;
6321: