APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_GRPINGS

Line 5234: -- ( kh.id in ( select INCLUDED_CHR_ID from okc_k_grpings

5230: -- (p_ForTDate IS NULL))
5231: -- AND kh.currency_code = NVL(p_curr,kh.currency_code)
5232: -- AND ((p_Contract_Group IS NULL)
5233: -- OR
5234: -- ( kh.id in ( select INCLUDED_CHR_ID from okc_k_grpings
5235: -- start with CGP_PARENT_ID = p_contract_group
5236: -- connect by CGP_PARENT_ID = PRIOR INCLUDED_CGP_ID )))
5237: -- ORDER BY kh.currency_code,kh.sts_code;
5238:

Line 5249: FROM okc_k_grpings

5245: FROM okc_k_headers_b kh,
5246: okc_statuses_b st,
5247: oks_k_headers_b rul,
5248: (SELECT included_chr_id
5249: FROM okc_k_grpings
5250: START WITH cgp_parent_id = p_contract_group
5251: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp
5252: WHERE kh.authoring_org_id = p_orgid
5253: AND kh.scs_code IN ('SERVICE', 'WARRANTY')

Line 5272: FROM okc_k_grpings

5268: FROM okc_k_headers_b kh,
5269: okc_statuses_b st,
5270: oks_k_headers_b rul,
5271: (SELECT included_chr_id
5272: FROM okc_k_grpings
5273: START WITH cgp_parent_id = p_contract_group
5274: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp
5275: WHERE kh.scs_code IN ('SERVICE', 'WARRANTY')
5276: AND kh.sts_code = st.code

Line 5294: FROM okc_k_grpings

5290: FROM okc_k_headers_b kh,
5291: okc_statuses_b st,
5292: oks_k_headers_b rul,
5293: (SELECT included_chr_id
5294: FROM okc_k_grpings
5295: START WITH cgp_parent_id = p_contract_group
5296: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp
5297: WHERE kh.authoring_org_id = p_orgid
5298: AND kh.scs_code IN ('SERVICE', 'WARRANTY')

Line 5316: FROM okc_k_grpings

5312: FROM okc_k_headers_b kh,
5313: okc_statuses_b st,
5314: oks_k_headers_b rul,
5315: (SELECT included_chr_id
5316: FROM okc_k_grpings
5317: START WITH cgp_parent_id = p_contract_group
5318: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp
5319: WHERE kh.scs_code IN ('SERVICE', 'WARRANTY')
5320: AND kh.sts_code = st.code