APPS.AST_ROUTING_PUB dependencies on OKC_K_HEADERS_B

Line 449: from okc_k_party_roles_b p , okc_k_headers_b k

445: l_more_partyID NUMBER;
446:
447: cursor getPartyIDfromContractNum (p_ContractNum VARCHAR2, p_ContractNumMod VARCHAR2 default null) is
448: select to_number(p.object1_id1)
449: from okc_k_party_roles_b p , okc_k_headers_b k
450: where k.contract_number = p_ContractNum
451: and k.contract_number_modifier = nvl(p_ContractNumMod, k.contract_number_modifier)
452: and k.id = p.dnz_chr_id
453: and p.primary_yn = 'Y'