APPS.PQH_RBC_UTILITY dependencies on PQH_RATE_FACTOR_ON_ELMNTS

Line 1127: l_rate_factor_id pqh_rate_factor_on_elmnts.rate_factor_on_elmnt_id%TYPE;

1123: end insert_rate_defn_tl;
1124:
1125: procedure sync_rate_factors_tables(critId in varchar2,
1126: parentId in varchar2) is
1127: l_rate_factor_id pqh_rate_factor_on_elmnts.rate_factor_on_elmnt_id%TYPE;
1128: cursor c1 is select rate_factor_on_elmnt_id from
1129: Pqh_rate_factor_on_elmnts rf, Pqh_criteria_rate_elements re
1130: where rf.criteria_rate_element_id = re.criteria_rate_element_id
1131: and re.criteria_rate_defn_id = critId

Line 1129: Pqh_rate_factor_on_elmnts rf, Pqh_criteria_rate_elements re

1125: procedure sync_rate_factors_tables(critId in varchar2,
1126: parentId in varchar2) is
1127: l_rate_factor_id pqh_rate_factor_on_elmnts.rate_factor_on_elmnt_id%TYPE;
1128: cursor c1 is select rate_factor_on_elmnt_id from
1129: Pqh_rate_factor_on_elmnts rf, Pqh_criteria_rate_elements re
1130: where rf.criteria_rate_element_id = re.criteria_rate_element_id
1131: and re.criteria_rate_defn_id = critId
1132: and rf.criteria_rate_factor_id = parentId;
1133: begin

Line 1137: delete from Pqh_rate_factor_on_elmnts

1133: begin
1134: open c1;
1135: loop
1136: fetch c1 into l_rate_factor_id;
1137: delete from Pqh_rate_factor_on_elmnts
1138: where rate_factor_on_elmnt_id = l_rate_factor_id;
1139: exit when c1%NOTFOUND;
1140: end loop;
1141: close c1;