1207: end is_crit_rate_name_uniq;
1208:
1209: PROCEDURE cascade_rate_factors_table(rateTypeId varchar2) IS
1210: BEGIN
1211: delete from Pqh_criteria_rate_factors
1212: where criteria_rate_defn_id = rateTypeId;
1213: END cascade_rate_factors_table;
1214:
1215: --
1243: Where table_alias = 'RCR'
1244: and copy_entity_txn_id = p_copy_entity_txn_id
1245: and (information1 = p_criteria_rate_defn_id OR
1246: information1 in (select criteria_rate_defn_id
1247: from pqh_criteria_rate_factors
1248: Where parent_criteria_rate_defn_id = p_criteria_rate_defn_id
1249: and (parent_rate_matrix_id is null or parent_rate_matrix_id = p_rate_matrix_id)
1250: )
1251: );
1380: AND table_alias = 'PLN';
1381: --
1382: Cursor csr_find_parent(p_rate_matrix_id in number, p_criteria_rate_defn_id in number) is
1383: select a.parent_criteria_rate_defn_id parent_id, b.name parent_name
1384: from pqh_criteria_rate_factors a, pqh_criteria_rate_defn_vl b
1385: Where a.criteria_rate_defn_id = p_criteria_rate_defn_id
1386: and (parent_rate_matrix_id is null or parent_rate_matrix_id = p_rate_matrix_id)
1387: and a.parent_criteria_rate_defn_id = b.criteria_rate_defn_id;
1388: --