DBA Data[Home] [Help]

APPS.OKS_OCINT_PUB dependencies on OKC_STATUSES_V

Line 842: From OKC_STATUSES_V sv,

838: Cursor l_hdr_ste_csr(p_chr_id Number) Is
839: Select sv.ste_code,
840: kh.contract_number||Decode(kh.contract_number_modifier,NULL,NULL,
841: ' - '||kh.contract_number_modifier) k_number
842: From OKC_STATUSES_V sv,
843: OKC_K_HEADERS_V kh
844: Where kh.id = p_chr_id
845: and kh.sts_code = sv.CODE;
846: /*end added for bugfix 14486901 by ansraj*/