APPS.PAY_US_RETRO_UPGRADE dependencies on PAY_LEGISLATION_RULES

Line 199: from pay_legislation_rules

195:
196: cursor c_retro_rule_check(cp_rule_type in varchar2
197: ,cp_legislation_code in Varchar2) is
198: select 'Y'
199: from pay_legislation_rules
200: where legislation_code = cp_legislation_code
201: and rule_type = cp_rule_type;
202:
203: ln_classification_id NUMBER;

Line 255: INSERT INTO pay_legislation_rules

251: FOR i in 1 ..3 LOOP
252: OPEN c_retro_rule_check(ltt_rule_type(i),lv_legislation_code) ;
253: FETCH c_retro_rule_check into ln_exists;
254: IF c_retro_rule_check%NOTFOUND THEN
255: INSERT INTO pay_legislation_rules
256: (legislation_code, rule_type, rule_mode) VALUES
257: (lv_legislation_code, ltt_rule_type(i), ltt_rule_mode(i));
258: END IF;
259: CLOSE c_retro_rule_check;