APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_SCA_CONDITIONS

Line 414: FROM cn_sca_conditions csc,

410: FROM cn_lookups cl
411: WHERE lookup_type = 'SCA_OPERATORS'
412: AND EXISTS (
413: SELECT 'S'
414: FROM cn_sca_conditions csc,
415: cn_sca_cond_details cscd
416: WHERE csc.sca_condition_id = cscd.sca_condition_id
417: AND csc.org_id = cscd.org_id -- vensrini
418: AND csc.org_id = g_org_id -- vensrini