DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on CS_BUSINESS_PROCESSES

Line 13291: cs_business_processes cbp

13287: CURSOR Check_update_only(p_coverage_id IN Gx_OKS_Id) IS
13288: SELECT 'Y'
13289: FROM okc_k_lines_v bp,
13290: okc_k_items cim,
13291: cs_business_processes cbp
13292: WHERE bp.cle_id = p_coverage_id
13293: AND cim.cle_id = bp.id
13294: AND cbp.business_process_id = cim.object1_id1
13295: AND cim.jtot_object1_code = 'OKX_BUSIPROC'

Line 15036: -- cs_business_processes bp

15032: -- lines2.dnz_chr_id
15033: -- from okc_k_lines_v lines,
15034: -- okc_k_lines_v lines2,
15035: -- okc_k_items items,
15036: -- cs_business_processes bp
15037: -- where lines.cle_id = p_line_id
15038: -- and lines.id = lines2.cle_id
15039: -- and lines.lse_id in (2,15,20)
15040: -- and lines2.id = items.cle_id

Line 15074: cs_business_processes bp

15070: from okc_k_lines_b lines,
15071: oks_k_lines_b KSL,
15072: okc_k_lines_v lines2,
15073: okc_k_items items,
15074: cs_business_processes bp
15075: where lines.id = p_line_id
15076: and lines.lse_id in (1,14,19)
15077: and KSL.cle_id = lines.id
15078: and KSL.Coverage_Id = lines2.cle_Id