APPS.PAY_US_RETRO_OVERLAP dependencies on PAY_LEGISLATION_RULES

Line 51: FROM pay_legislation_rules

47: CURSOR c_retro_rule_check( cp_rule_type IN varchar2
48: ,cp_legislation_code IN Varchar2)
49: IS
50: SELECT rule_mode
51: FROM pay_legislation_rules
52: WHERE legislation_code = cp_legislation_code
53: AND rule_type = cp_rule_type;
54:
55: -- Cursor to fetch upgrade definition id of Enhanced Retropay

Line 210: UPDATE pay_legislation_rules

206: THEN
207: fnd_file.put_line(fnd_file.log,'Retro Overlap is already Enabled');
208: ELSE
209: -- Updating Rero Ovelap rule mode to N
210: UPDATE pay_legislation_rules
211: SET RULE_MODE = ltt_rule_mode(3)
212: WHERE legislation_code = lv_legislation_code
213: AND rule_type = ltt_rule_type(3);
214: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');

Line 219: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)

215: END IF;
216:
217: ELSE
218: --If Retro Overlap is not enabled inserting new legislation rule
219: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
220: VALUES( lv_legislation_code,ltt_rule_type(3),ltt_rule_mode(3));
221: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
222: END IF;
223:

Line 313: UPDATE pay_legislation_rules

309: THEN
310: fnd_file.put_line(fnd_file.log,'Retro Overlap is already Enabled');
311: ELSE
312: -- Updating Rero Ovelap rule mode to N
313: UPDATE pay_legislation_rules
314: SET RULE_MODE = ltt_rule_mode(3)
315: WHERE legislation_code = lv_legislation_code
316: AND rule_type = ltt_rule_type(3);
317: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');

Line 321: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)

317: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
318: END IF;
319: ELSE
320: --If Retro Overlap is not enabled inserting new legislation rule
321: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
322: VALUES( lv_legislation_code,ltt_rule_type(3),ltt_rule_mode(3));
323: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
324: END IF;
325: