APPS.OKL_OPI_PVT dependencies on OKC_K_HEADERS_V

Line 668: FROM okc_k_headers_v

664: l_organization_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE;
665:
666: CURSOR l_report_all_csr(cp_organization_id IN NUMBER) IS
667: SELECT id
668: FROM okc_k_headers_v
669: WHERE authoring_org_id = cp_organization_id
670: AND scs_code = 'LEASE';
671: BEGIN
672: --get organization id

Line 1092: FROM okc_k_headers_v okhv

1088: ,okhv.start_date
1089: ,nvl(okhv.date_terminated, okhv.end_date) close_date
1090: ,okh.term_duration
1091: ,okhv.authoring_org_id
1092: FROM okc_k_headers_v okhv
1093: ,okl_k_headers okh
1094: WHERE okhv.id = cp_contract_id
1095: AND okhv.id = okh.id;
1096: