APPS.PAY_CA_RETRO_OVERLAP dependencies on PAY_LEGISLATION_RULES

Line 32: FROM pay_legislation_rules

28: CURSOR c_retro_rule_check( cp_rule_type IN varchar2
29: ,cp_legislation_code IN Varchar2)
30: IS
31: SELECT rule_mode
32: FROM pay_legislation_rules
33: WHERE legislation_code = cp_legislation_code
34: AND rule_type = cp_rule_type;
35:
36: -- Cursor to fetch upgrade definition id of Enhanced Retropay

Line 129: UPDATE pay_legislation_rules

125: THEN
126: fnd_file.put_line(fnd_file.log,'Retro Overlap is already Enabled');
127: ELSE
128: -- Updating Rero Ovelap rule mode to N
129: UPDATE pay_legislation_rules
130: SET RULE_MODE = ltt_rule_mode(3)
131: WHERE legislation_code = lv_legislation_code
132: AND rule_type = ltt_rule_type(3);
133: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');

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

134: END IF;
135:
136: ELSE
137: --If Retro Overlap is not enabled inserting new legislation rule
138: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
139: VALUES( lv_legislation_code,ltt_rule_type(3),ltt_rule_mode(3));
140: fnd_file.put_line(fnd_file.log,'Retro Overlap Enabled successfully');
141: END IF;
142: