APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on OKC_REP_CONTRACT_PARTIES

Line 518: FROM okc_rep_contract_parties con_parties

514: Okc_bus_doc_types_b doc_type_b,
515: Okc_bus_doc_types_tl doc_type_tl
516: WHERE (p_cust_id IS NULL OR EXISTS (
517: SELECT con_parties.party_id
518: FROM okc_rep_contract_parties con_parties
519: WHERE header.contract_id = con_parties.contract_id
520: AND con_parties.party_id = p_cust_id
521: AND (con_parties.party_role_code = 'PARTNER_ORG' OR
522: con_parties.party_role_code = 'CUSTOMER_ORG')))

Line 537: FROM okc_rep_contract_parties con_party,

533: header.owner_id <> p_new_con_admin_user_id);
534:
535: CURSOR cust_names_csr (p_contract_id IN NUMBER) IS
536: SELECT hz.party_name
537: FROM okc_rep_contract_parties con_party,
538: hz_parties hz
539: WHERE con_party.contract_id = p_contract_id
540: AND (con_party.party_role_code = 'CUSTOMER_ORG' OR
541: con_party.party_role_code = 'PARTNER_ORG')