DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on CS_BUSINESS_PROCESSES

Line 14649: cs_business_processes cbp

14645: CURSOR Check_update_only(p_coverage_id IN Gx_OKS_Id) IS
14646: SELECT 'Y'
14647: FROM okc_k_lines_v bp,
14648: okc_k_items cim,
14649: cs_business_processes cbp
14650: WHERE bp.cle_id = p_coverage_id
14651: AND cim.cle_id = bp.id
14652: AND cbp.business_process_id = cim.object1_id1
14653: AND cim.jtot_object1_code = 'OKX_BUSIPROC'

Line 16439: -- cs_business_processes bp

16435: -- lines2.dnz_chr_id
16436: -- from okc_k_lines_v lines,
16437: -- okc_k_lines_v lines2,
16438: -- okc_k_items items,
16439: -- cs_business_processes bp
16440: -- where lines.cle_id = p_line_id
16441: -- and lines.id = lines2.cle_id
16442: -- and lines.lse_id in (2,15,20)
16443: -- and lines2.id = items.cle_id

Line 16477: cs_business_processes bp

16473: from okc_k_lines_b lines,
16474: oks_k_lines_b KSL,
16475: okc_k_lines_v lines2,
16476: okc_k_items items,
16477: cs_business_processes bp
16478: where lines.id = p_line_id
16479: and lines.lse_id in (1,14,19)
16480: and KSL.cle_id = lines.id
16481: and KSL.Coverage_Id = lines2.cle_Id