APPS.PAY_GB_RETRO_OVERLAP dependencies on PAY_LEGISLATION_RULES

Line 20: FROM pay_legislation_rules

16: CURSOR c_retro_rule_check( cp_rule_type IN varchar2
17: ,cp_legislation_code IN Varchar2)
18: IS
19: SELECT rule_mode
20: FROM pay_legislation_rules
21: WHERE legislation_code = cp_legislation_code
22: AND rule_type = cp_rule_type;
23:
24: -- Cursor to fetch upgrade definition id of Enhanced Retropay

Line 117: UPDATE pay_legislation_rules

113: THEN
114: fnd_file.put_line(fnd_file.log,'Retro Overlap is already Enabled');
115: ELSE
116: -- Updating Rero Ovelap rule mode to N
117: UPDATE pay_legislation_rules
118: SET RULE_MODE = ltt_rule_mode(3)
119: WHERE legislation_code = lv_legislation_code
120: AND rule_type = ltt_rule_type(3);
121: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');

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

122: END IF;
123:
124: ELSE
125: --If Retro Overlap is not enabled inserting new legislation rule
126: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
127: VALUES( lv_legislation_code,ltt_rule_type(3),ltt_rule_mode(3));
128: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
129: END IF;
130: