DBA Data[Home] [Help]

APPS.AST_UWQ_SEL_PKG dependencies on OKC_K_HEADERS_B

Line 627: FROM okc_k_party_roles_b p , okc_k_headers_b k

623: PROCEDURE getDtlsFromContractNum IS
624:
625: CURSOR C_getDtlsFromContractNum(x_ContractNum varchar2, x_ContractNumMod varchar2 default null) IS
626: SELECT to_number(p.object1_id1)
627: FROM okc_k_party_roles_b p , okc_k_headers_b k
628: where k.contract_number = x_ContractNum
629: and k.contract_number_modifier = nvl(x_ContractNumMod, k.contract_number_modifier)
630: and k.id = p.dnz_chr_id
631: and p.primary_yn = 'Y'