APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_RESP_PARTIES_B

Line 2056: from okc_resp_parties_b resp, okc_bus_doc_types_b busdoc

2052:
2053: -- 11.5.10+ code bug#4148082
2054: cursor getExtPartyRole is
2055: select resp.resp_party_code
2056: from okc_resp_parties_b resp, okc_bus_doc_types_b busdoc
2057: where resp.document_type_class = busdoc.document_type_class
2058: and resp.intent = busdoc.intent
2059: and resp.internal_external_flag = 'EXTERNAL'
2060: and busdoc.document_type = p_target_doc_type;

Line 2061: l_ext_party_role okc_resp_parties_b.resp_party_code%TYPE;

2057: where resp.document_type_class = busdoc.document_type_class
2058: and resp.intent = busdoc.intent
2059: and resp.internal_external_flag = 'EXTERNAL'
2060: and busdoc.document_type = p_target_doc_type;
2061: l_ext_party_role okc_resp_parties_b.resp_party_code%TYPE;
2062:
2063: --ER Structured Terms Authoring in Repository strivedi
2064: CURSOR getRepDefaultInternalContactId IS
2065: SELECT pf.person_id contact_id