APPS.OKS_UTIL_PUB dependencies on OKC_K_HEADERS_B

Line 525: FROM okc_k_headers_b hdr

521: CURSOR CONTRACT_HDR_1(cp_contract_id NUMBER
522: ,cp_group_id NUMBER)
523: IS
524: SELECT hdr.id hdr_id, authoring_org_id org_id
525: FROM okc_k_headers_b hdr
526: WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
527: AND Hdr.Template_yn = 'N'
528: AND exists (Select 'x' from OKC_K_GRPINGS okg
529: Where okg.included_chr_id = hdr.id

Line 539: FROM okc_k_headers_b hdr

535: --cp_group_id is null
536: CURSOR CONTRACT_HDR_2(cp_contract_id NUMBER)
537: IS
538: SELECT hdr.id hdr_id, authoring_org_id org_id
539: FROM okc_k_headers_b hdr
540: WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
541: AND Hdr.Template_yn = 'N'
542: AND Hdr.id = CP_CONTRACT_ID;
543:

Line 550: FROM okc_k_headers_b hdr

546: --cp_group_id is not null
547: CURSOR CONTRACT_HDR_3(cp_group_id NUMBER)
548: IS
549: SELECT hdr.id hdr_id, authoring_org_id org_id
550: FROM okc_k_headers_b hdr
551: WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
552: AND Hdr.Template_yn = 'N'
553: AND exists (Select 'x' from OKC_K_GRPINGS okg
554: Where okg.included_chr_id = hdr.id

Line 563: FROM okc_k_headers_b HDR

559:
560: CURSOR CONTRACT_HDR_4
561: IS
562: SELECT /*+ PARALLEL(HDR) */ hdr.id hdr_id, authoring_org_id org_id
563: FROM okc_k_headers_b HDR
564: WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
565: AND Hdr.Template_yn = 'N';
566:
567: ----------------------------