APPS.CN_SCA_RULES_ONLINE_GEN_PVT dependencies on CN_SCA_CONDITIONS

Line 293: FROM cn_sca_conditions csc

289: -- codeCheck: This condition is not required when inner has it.
290: AND org_id = g_org_id
291: -- AND enabled_flag = 'Y'
292: AND EXISTS (SELECT 'S'
293: FROM cn_sca_conditions csc
294: WHERE csc.sca_rule_attribute_id = csra.sca_rule_attribute_id
295: AND csc.org_id = g_org_id) ;
296:
297: CURSOR cn_operators (a_sca_rule_attribute_id NUMBER) IS

Line 302: FROM cn_sca_conditions csc ,

298: SELECT lookup_code,meaning
299: FROM cn_lookups cl
300: WHERE lookup_type = 'SCA_OPERATORS'
301: AND EXISTS (SELECT 'x'
302: FROM cn_sca_conditions csc ,
303: cn_sca_cond_details cscd
304: WHERE csc.sca_condition_id = cscd.sca_condition_id
305: AND csc.sca_rule_attribute_id = a_sca_rule_attribute_id
306: AND csc.org_id = g_org_id