APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_GRPINGS

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

5184: -- (p_ForTDate IS NULL))
5185: -- AND kh.currency_code = NVL(p_curr,kh.currency_code)
5186: -- AND ((p_Contract_Group IS NULL)
5187: -- OR
5188: -- ( kh.id in ( select INCLUDED_CHR_ID from okc_k_grpings
5189: -- start with CGP_PARENT_ID = p_contract_group
5190: -- connect by CGP_PARENT_ID = PRIOR INCLUDED_CGP_ID )))
5191: -- ORDER BY kh.currency_code,kh.sts_code;
5192:

Line 5203: FROM okc_k_grpings

5199: FROM okc_k_headers_b kh,
5200: okc_statuses_b st,
5201: oks_k_headers_b rul,
5202: (SELECT included_chr_id
5203: FROM okc_k_grpings
5204: START WITH cgp_parent_id = p_contract_group
5205: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp
5206: WHERE kh.authoring_org_id = p_orgid
5207: AND kh.scs_code IN ('SERVICE', 'WARRANTY')

Line 5226: FROM okc_k_grpings

5222: FROM okc_k_headers_b kh,
5223: okc_statuses_b st,
5224: oks_k_headers_b rul,
5225: (SELECT included_chr_id
5226: FROM okc_k_grpings
5227: START WITH cgp_parent_id = p_contract_group
5228: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp
5229: WHERE kh.scs_code IN ('SERVICE', 'WARRANTY')
5230: AND kh.sts_code = st.code

Line 5248: FROM okc_k_grpings

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

Line 5270: FROM okc_k_grpings

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