APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_LEGISLATION_RULES

Line 164: FROM hr_s_legislation_rules

160:
161:
162: CURSOR get_leg_rules_csr IS
163: SELECT rule_type
164: FROM hr_s_legislation_rules
165: WHERE legislation_code = 'ZZ';
166:
167: CURSOR get_balance_class_csr IS
168: SELECT distinct pbc.balance_classification_id, pbt.balance_name bname

Line 228: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Legislation Rules', 'HR_S_LEGISLATION_RULES');

224: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Legislative Field Info', rec.field_name);
225: END LOOP;
226:
227: write_log('OUTPUT',NULL,NULL,NULL);
228: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Legislation Rules', 'HR_S_LEGISLATION_RULES');
229:
230: FOR rec IN get_leg_rules_csr LOOP
231: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Legislation Rule', rec.rule_type);
232: END LOOP;

Line 548: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_RULES',NULL);

544: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_WC_STATE_SURCHARGES',NULL);
545: DELETE hr_s_wc_state_surcharges;
546: COMMIT;
547:
548: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_RULES',NULL);
549: DELETE hr_s_legislation_rules;
550: COMMIT;
551:
552: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_TAXABILITY_RULES_DATES',NULL);

Line 549: DELETE hr_s_legislation_rules;

545: DELETE hr_s_wc_state_surcharges;
546: COMMIT;
547:
548: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_RULES',NULL);
549: DELETE hr_s_legislation_rules;
550: COMMIT;
551:
552: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_TAXABILITY_RULES_DATES',NULL);
553: DELETE HR_S_TAXABILITY_RULES_DATES;

Line 696: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','Legislation Rules', 'HR_S_LEGISLATION_RULES');

692:
693: BEGIN
694: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',10);
695: --Legislation Rules
696: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','Legislation Rules', 'HR_S_LEGISLATION_RULES');
697:
698: INSERT INTO hr_s_application_ownerships
699: (key_name
700: ,product_name

Line 1407: INSERT INTO hr_s_legislation_rules

1403:
1404: BEGIN
1405: hr_utility.set_location('pay_ip_startup_util.create_flex_leg_rule ',10);
1406:
1407: INSERT INTO hr_s_legislation_rules
1408: ( legislation_code
1409: ,rule_type
1410: ,rule_mode)
1411: SELECT

Line 1417: FROM hr_s_legislation_rules

1413: ,p_rule_type
1414: ,p_rule_mode
1415: FROM dual
1416: WHERE NOT EXISTS (SELECT NULL
1417: FROM hr_s_legislation_rules
1418: WHERE legislation_code = 'ZZ'
1419: AND rule_type = p_rule_type);
1420: IF SQL%NOTFOUND THEN
1421: UPDATE hr_s_legislation_rules SET

Line 1421: UPDATE hr_s_legislation_rules SET

1417: FROM hr_s_legislation_rules
1418: WHERE legislation_code = 'ZZ'
1419: AND rule_type = p_rule_type);
1420: IF SQL%NOTFOUND THEN
1421: UPDATE hr_s_legislation_rules SET
1422: rule_mode = p_rule_mode
1423: WHERE legislation_code = 'ZZ'
1424: AND rule_type = p_rule_type;
1425: END IF;

Line 1470: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATION_RULES',NULL);

1466: WHERE legislation_code = 'ZZ';
1467:
1468: --Updating Legislation Rules Table
1469:
1470: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATION_RULES',NULL);
1471: UPDATE hr_s_legislation_rules
1472: SET legislation_code = p_legislation_code
1473: WHERE legislation_code = 'ZZ';
1474:

Line 1471: UPDATE hr_s_legislation_rules

1467:
1468: --Updating Legislation Rules Table
1469:
1470: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATION_RULES',NULL);
1471: UPDATE hr_s_legislation_rules
1472: SET legislation_code = p_legislation_code
1473: WHERE legislation_code = 'ZZ';
1474:
1475: --Unpadting Legislative Field Info