APPS.CN_SCA_INTERFACE_MAP_PVT dependencies on CN_SCA_RULE_ATTRIBUTES

Line 574: -- CN_SCA_RULE_ATTRIBUTES.SRC_COLUMN_NAME

570: l_loop_cntr2 INTEGER := 1;
571: l_loop_cntr3 INTEGER := 1;
572: ------++
573: -- PL/SQL Table type and Variable declaration for
574: -- CN_SCA_RULE_ATTRIBUTES.SRC_COLUMN_NAME
575: ------++
576: TYPE src_column_name
577: IS TABLE OF VARCHAR2(4000)
578: INDEX BY BINARY_INTEGER;

Line 582: -- CN_SCA_RULE_ATTRIBUTES.TRX_SRC_COLUMN_NAME

578: INDEX BY BINARY_INTEGER;
579: l_src_column_name src_column_name;
580: ------++
581: -- PL/SQL Table type and Variable declaration for
582: -- CN_SCA_RULE_ATTRIBUTES.TRX_SRC_COLUMN_NAME
583: ------++
584: TYPE trx_src_column_name
585: IS TABLE OF VARCHAR2(4000)
586: INDEX BY BINARY_INTEGER;

Line 590: -- TRANSACTION SOURCE Mapping column names from CN_SCA_RULE_ATTRIBUTES

586: INDEX BY BINARY_INTEGER;
587: l_trx_src_column_name trx_src_column_name;
588: ------++
589: -- Cursor and Variable declaration to get SOURCE and
590: -- TRANSACTION SOURCE Mapping column names from CN_SCA_RULE_ATTRIBUTES
591: ------++
592: CURSOR cn_sca_rule_attr_cur
593: IS
594: SELECT sca_rule_attribute_id,

Line 598: FROM cn_sca_rule_attributes

594: SELECT sca_rule_attribute_id,
595: LOWER(src_column_name) src_column_name,
596: LOWER(user_column_name) user_column_name,
597: LOWER(trx_src_column_name) trx_src_column_name
598: FROM cn_sca_rule_attributes
599: WHERE transaction_source = 'CN'
600: AND org_id = p_org_id -- MOAC Change
601: ORDER BY src_column_name;
602: