DBA Data[Home] [Help]

APPS.OKS_OCINT_PUB dependencies on OKC_K_HEADERS_V

Line 834: FROM okc_k_headers_v

830:
831: CURSOR l_hdr_scs_csr (p_chr_id NUMBER)
832: IS
833: SELECT scs_code
834: FROM okc_k_headers_v
835: WHERE ID = p_chr_id;
836:
837: /*added for bugfix 14486901 by ansraj*/
838: Cursor l_hdr_ste_csr(p_chr_id Number) Is

Line 843: OKC_K_HEADERS_V kh

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*/
847: