APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_LEGISLATION_RULES

Line 1580: from pay_legislation_rules

1576:
1577: cursor c_retro_rule_check(cp_rule_type in varchar2
1578: ,cp_legislation_code in Varchar2) is
1579: select 'Y'
1580: from pay_legislation_rules
1581: where legislation_code = cp_legislation_code
1582: and rule_type = cp_rule_type;
1583:
1584: ln_classification_id NUMBER;

Line 1658: INSERT INTO pay_legislation_rules

1654: FOR i in 1 ..2 LOOP
1655: OPEN c_retro_rule_check(ltt_rule_type(i),lv_legislation_code) ;
1656: FETCH c_retro_rule_check into ln_exists;
1657: IF c_retro_rule_check%NOTFOUND THEN
1658: INSERT INTO pay_legislation_rules
1659: (legislation_code, rule_type, rule_mode) VALUES
1660: (lv_legislation_code, ltt_rule_type(i), ltt_rule_mode(i));
1661: END IF;
1662: CLOSE c_retro_rule_check;

Line 2268: FROM pay_legislation_rules

2264:
2265: CURSOR get_leg_rule
2266: IS
2267: SELECT rule_mode
2268: FROM pay_legislation_rules
2269: WHERE rule_type = 'ADVANCED_RETRO'
2270: AND legislation_code = 'AU';
2271:
2272: CURSOR csr_exists

Line 2275: FROM pay_legislation_rules

2271:
2272: CURSOR csr_exists
2273: IS
2274: SELECT count(*)
2275: FROM pay_legislation_rules
2276: WHERE rule_type = 'ADVANCED_RETRO'
2277: AND legislation_code = 'AU';
2278:
2279:

Line 2327: INSERT INTO pay_legislation_rules

2323: FETCH csr_exists INTO l_exists;
2324: CLOSE csr_exists;
2325:
2326: IF l_exists = 0 THEN
2327: INSERT INTO pay_legislation_rules
2328: (rule_type
2329: ,rule_mode
2330: ,legislation_code)
2331: VALUES

Line 2337: UPDATE pay_legislation_rules

2333: ,'Y'
2334: ,'AU');
2335: l_return_flag := 'Y';
2336: ELSE
2337: UPDATE pay_legislation_rules
2338: SET rule_mode = 'Y'
2339: WHERE rule_type = 'ADVANCED_RETRO'
2340: AND legislation_code = 'AU' ;
2341: l_return_flag := 'Y';