eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SCA_DENORM_RULES_PVT dependencies on CN_SCA_COMBINATIONS

Line 165: -- into cn_sca_combinations

161: --
162: END LOOP;
163: --
164: -- Populate Rule Attributes associated with each distinct rule_attr_comb_id
165: -- into cn_sca_combinations
166: --
167: IF (l_delete_flag = 'Y') THEN
168: DELETE FROM cn_sca_combinations
169: WHERE transaction_source = p_transaction_source

Line 168: DELETE FROM cn_sca_combinations

164: -- Populate Rule Attributes associated with each distinct rule_attr_comb_id
165: -- into cn_sca_combinations
166: --
167: IF (l_delete_flag = 'Y') THEN
168: DELETE FROM cn_sca_combinations
169: WHERE transaction_source = p_transaction_source
170: AND org_id = p_org_id;
171: --
172: FOR get_attr_rec IN get_attr_cur

Line 174: INSERT INTO cn_sca_combinations(

170: AND org_id = p_org_id;
171: --
172: FOR get_attr_rec IN get_attr_cur
173: LOOP
174: INSERT INTO cn_sca_combinations(
175: sca_rule_attribute_id,
176: rule_attr_comb_value,
177: transaction_source,
178: created_by,