DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_RESP_PARTIES_B

Line 1940: from okc_resp_parties_b resp, okc_bus_doc_types_b busdoc

1936:
1937: -- 11.5.10+ code bug#4148082
1938: cursor getExtPartyRole is
1939: select resp.resp_party_code
1940: from okc_resp_parties_b resp, okc_bus_doc_types_b busdoc
1941: where resp.document_type_class = busdoc.document_type_class
1942: and resp.intent = busdoc.intent
1943: and resp.internal_external_flag = 'EXTERNAL'
1944: and busdoc.document_type = p_target_doc_type;

Line 1945: l_ext_party_role okc_resp_parties_b.resp_party_code%TYPE;

1941: where resp.document_type_class = busdoc.document_type_class
1942: and resp.intent = busdoc.intent
1943: and resp.internal_external_flag = 'EXTERNAL'
1944: and busdoc.document_type = p_target_doc_type;
1945: l_ext_party_role okc_resp_parties_b.resp_party_code%TYPE;
1946:
1947: --ER Structured Terms Authoring in Repository strivedi
1948: CURSOR getRepDefaultInternalContactId IS
1949: SELECT pf.person_id contact_id