APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_SCA_COND_DETAILS

Line 415: cn_sca_cond_details cscd

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
419: AND cscd.OPERATOR_ID = cl.lookup_code