APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_PARTY_CONTACTS

Line 482: FROM okc_rep_party_contacts c, fnd_user usr

478: WHERE contract_id = p_contract_id;
479:
480: CURSOR contract_signers_csr(p_contract_id in number) IS
481: SELECT usr.user_id
482: FROM okc_rep_party_contacts c, fnd_user usr
483: WHERE c.contract_id = p_contract_id
484: AND c.esignature_type = 'SELF'
485: AND usr.employee_id = c.contact_id;
486:

Line 2445: FROM okc_rep_party_contacts

2441:
2442:
2443: CURSOR contact_unique_csr IS
2444: SELECT 1
2445: FROM okc_rep_party_contacts
2446: WHERE contract_id = p_contract_id
2447: AND party_id = p_party_id
2448: AND party_role_code = p_party_role_code
2449: AND contact_id = p_contact_id

Line 5970: INSERT INTO okc_rep_party_contacts

5966: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_con_status_hist *****');
5967:
5968: --kkolukul
5969: --insert into party contacts
5970: INSERT INTO okc_rep_party_contacts
5971: ( contract_id,
5972: party_id,
5973: party_role_code,
5974: contact_id,

Line 6011: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_party_contacts *****');

6007: AND contract_id >= l_start_contract_id
6008: AND contract_id < l_start_contract_id + l_insert_batch_size;
6009:
6010:
6011: FND_FILE.PUT_LINE(FND_FILE.LOG, '***** INSERT INTO okc_rep_party_contacts *****');
6012:
6013: --insert into contract risks
6014: INSERT INTO okc_contract_risks
6015: (business_document_type,

Line 7032: FROM OKC_REP_PARTY_CONTACTS

7028: l_index NUMBER;
7029:
7030: CURSOR vendor_contact_csr IS
7031: SELECT contact_id
7032: FROM OKC_REP_PARTY_CONTACTS
7033: WHERE contract_id = p_document_id
7034: AND party_id = p_external_party_id
7035: AND party_role_code = G_PARTY_ROLE_SUPPLIER;
7036:

Line 7200: FROM OKC_REP_PARTY_CONTACTS

7196: l_index NUMBER;
7197:
7198: CURSOR tca_contact_csr IS
7199: SELECT contact_id
7200: FROM OKC_REP_PARTY_CONTACTS
7201: WHERE contract_id = p_document_id
7202: AND party_id = p_external_party_id
7203: AND party_role_code = p_external_party_role;
7204: