APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_LEGISLATION_RULES

Line 1789: from pay_legislation_rules

1785:
1786: cursor c_retro_rule_check(cp_rule_type in varchar2
1787: ,cp_legislation_code in Varchar2) is
1788: select 'Y'
1789: from pay_legislation_rules
1790: where legislation_code = cp_legislation_code
1791: and rule_type = cp_rule_type;
1792:
1793: ln_classification_id NUMBER;

Line 1867: INSERT INTO pay_legislation_rules

1863: FOR i in 1 ..2 LOOP
1864: OPEN c_retro_rule_check(ltt_rule_type(i),lv_legislation_code) ;
1865: FETCH c_retro_rule_check into ln_exists;
1866: IF c_retro_rule_check%NOTFOUND THEN
1867: INSERT INTO pay_legislation_rules
1868: (legislation_code, rule_type, rule_mode) VALUES
1869: (lv_legislation_code, ltt_rule_type(i), ltt_rule_mode(i));
1870: END IF;
1871: CLOSE c_retro_rule_check;

Line 2537: FROM pay_legislation_rules

2533:
2534: CURSOR get_leg_rule
2535: IS
2536: SELECT rule_mode
2537: FROM pay_legislation_rules
2538: WHERE rule_type = 'ADVANCED_RETRO'
2539: AND legislation_code = 'AU';
2540:
2541: CURSOR csr_exists

Line 2544: FROM pay_legislation_rules

2540:
2541: CURSOR csr_exists
2542: IS
2543: SELECT count(*)
2544: FROM pay_legislation_rules
2545: WHERE rule_type = 'ADVANCED_RETRO'
2546: AND legislation_code = 'AU';
2547:
2548:

Line 2596: INSERT INTO pay_legislation_rules

2592: FETCH csr_exists INTO l_exists;
2593: CLOSE csr_exists;
2594:
2595: IF l_exists = 0 THEN
2596: INSERT INTO pay_legislation_rules
2597: (rule_type
2598: ,rule_mode
2599: ,legislation_code)
2600: VALUES

Line 2606: UPDATE pay_legislation_rules

2602: ,'Y'
2603: ,'AU');
2604: l_return_flag := 'Y';
2605: ELSE
2606: UPDATE pay_legislation_rules
2607: SET rule_mode = 'Y'
2608: WHERE rule_type = 'ADVANCED_RETRO'
2609: AND legislation_code = 'AU' ;
2610: l_return_flag := 'Y';

Line 3211: FROM pay_legislation_rules

3207:
3208: CURSOR csr_exists
3209: IS
3210: SELECT count(*)
3211: FROM pay_legislation_rules
3212: WHERE rule_type = 'RETRO_STATUS_USER_UPD'
3213: AND legislation_code = 'AU';
3214:
3215:

Line 3236: INSERT INTO pay_legislation_rules

3232: FETCH csr_exists INTO l_exists;
3233: CLOSE csr_exists;
3234:
3235: IF l_exists = 0 THEN
3236: INSERT INTO pay_legislation_rules
3237: (rule_type
3238: ,rule_mode
3239: ,legislation_code)
3240: VALUES

Line 3245: UPDATE pay_legislation_rules

3241: ('RETRO_STATUS_USER_UPD'
3242: ,'Y'
3243: ,'AU');
3244: ELSE
3245: UPDATE pay_legislation_rules
3246: SET rule_mode = 'Y'
3247: WHERE rule_type = 'RETRO_STATUS_USER_UPD'
3248: AND legislation_code = 'AU' ;
3249: END IF;

Line 3724: FROM pay_legislation_rules

3720: IS
3721: CURSOR c_retro_rule_check( cp_rule_type IN varchar2 )
3722: IS
3723: SELECT rule_mode
3724: FROM pay_legislation_rules
3725: WHERE legislation_code = g_legislation_code
3726: AND rule_type = cp_rule_type;
3727:
3728: CURSOR csr_exists

Line 3731: FROM pay_legislation_rules

3727:
3728: CURSOR csr_exists
3729: IS
3730: SELECT count(*)
3731: FROM pay_legislation_rules
3732: WHERE rule_type = 'RETRO_OVERLAP'
3733: AND legislation_code = 'AU';
3734:
3735: CURSOR csr_get_business_group_name IS

Line 3773: INSERT INTO pay_legislation_rules

3769: FETCH csr_exists INTO l_exists;
3770: CLOSE csr_exists;
3771:
3772: IF l_exists = 0 THEN
3773: INSERT INTO pay_legislation_rules
3774: ( rule_type
3775: ,rule_mode
3776: ,legislation_code)
3777: VALUES

Line 3782: UPDATE pay_legislation_rules

3778: ('RETRO_OVERLAP'
3779: ,'N'
3780: ,'AU');
3781: ELSE
3782: UPDATE pay_legislation_rules
3783: SET RULE_MODE = 'N'
3784: WHERE legislation_code = g_legislation_code
3785: AND rule_type = 'RETRO_OVERLAP';
3786: END IF;