APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_SCA_COMBINATIONS

Line 391: FROM cn_sca_combinations sc

387: --
388: -- Cursors Section
389: CURSOR comb_cur IS
390: SELECT distinct rule_attr_comb_value
391: FROM cn_sca_combinations sc
392: WHERE transaction_source = x_transaction_source
393: AND org_id = g_org_id; -- vensrini
394: --
395: CURSOR rule_attr_cur(l_comb_value NUMBER) IS

Line 399: FROM cn_sca_combinations sc,

395: CURSOR rule_attr_cur(l_comb_value NUMBER) IS
396: SELECT ra.sca_rule_attribute_id,
397: ra.src_column_name,
398: ra.datatype
399: FROM cn_sca_combinations sc,
400: cn_sca_rule_attributes ra
401: WHERE sc.sca_rule_attribute_id = ra.sca_rule_attribute_id
402: AND sc.org_id = ra.org_id --vensrini
403: AND sc.org_id = g_org_id -- vensrini

Line 458: cn_utils.appendcr(body_code, ' FROM cn_sca_combinations sc ');

454: cn_utils.appendcr(body_code, '-- Cursor to get Rule Attribute Combinations');
455: cn_utils.appendcr(body_code, '--+');
456: cn_utils.appendcr(body_code, ' CURSOR comb_cur IS ');
457: cn_utils.appendcr(body_code, ' SELECT DISTINCT rule_attr_comb_value ');
458: cn_utils.appendcr(body_code, ' FROM cn_sca_combinations sc ');
459: cn_utils.appendcr(body_code, ' WHERE transaction_source = p_transaction_source');
460: cn_utils.appendcr(body_code, ' AND org_id = p_org_id;'); -- vensrini
461: --
462: cn_utils.appendcr(body_code, 'BEGIN ');

Line 548: cn_utils.appendcr(body_code, ' FROM cn_sca_combinations sc ');

544: cn_utils.appendcr(body_code, ' AND b.sca_rule_attribute_id = (');
545: cn_utils.appendcr(body_code, ' SELECT DISTINCT sca_rule_attribute_id ');
546: cn_utils.appendcr(body_code, ' FROM ( SELECT a.*, rownum rnum ');
547: cn_utils.appendcr(body_code, ' FROM ( SELECT sca_rule_attribute_id ');
548: cn_utils.appendcr(body_code, ' FROM cn_sca_combinations sc ');
549: cn_utils.appendcr(body_code, ' WHERE sc.rule_attr_comb_value = l_comb_value_id ');
550: cn_utils.appendcr(body_code, ' AND sc.org_id = p_org_id ');
551: cn_utils.appendcr(body_code, ' ORDER BY sc.sca_rule_attribute_id) a ');
552: cn_utils.appendcr(body_code, ' WHERE rownum <= '||l_row_num||') ');