eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RETRO_UPGRADE dependencies on PAY_LEGISLATION_RULES

Line 198: from pay_legislation_rules

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

Line 267: delete pay_legislation_rules

263: FETCH c_retro_rule_check into ln_exists;
264:
265: IF c_retro_rule_check%FOUND THEN
266:
267: delete pay_legislation_rules
268: where legislation_code = lv_legislation_code
269: and rule_type = ltt_rule_type(i);
270:
271: END IF;

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

269: and rule_type = ltt_rule_type(i);
270:
271: END IF;
272:
273: INSERT INTO pay_legislation_rules(legislation_code,rule_type,rule_mode)
274: VALUES( lv_legislation_code,ltt_rule_type(i),ltt_rule_mode(i));
275:
276: CLOSE c_retro_rule_check;
277: