APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_LEGISLATION_RULES

Line 170: FROM hr_s_legislation_rules

166:
167:
168: CURSOR get_leg_rules_csr IS
169: SELECT rule_type
170: FROM hr_s_legislation_rules
171: WHERE legislation_code = 'ZZ';
172:
173: CURSOR get_balance_class_csr IS
174: SELECT distinct pbc.balance_classification_id, pbt.balance_name bname

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

230: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Legislative Field Info', rec.field_name);
231: END LOOP;
232:
233: write_log('OUTPUT',NULL,NULL,NULL);
234: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Legislation Rules', 'HR_S_LEGISLATION_RULES');
235:
236: FOR rec IN get_leg_rules_csr LOOP
237: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Legislation Rule', rec.rule_type);
238: END LOOP;

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

606: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_WC_STATE_SURCHARGES',NULL);
607: DELETE hr_s_wc_state_surcharges;
608: COMMIT;
609:
610: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_RULES',NULL);
611: DELETE hr_s_legislation_rules;
612: COMMIT;
613:
614: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_TAXABILITY_RULES_DATES',NULL);

Line 611: DELETE hr_s_legislation_rules;

607: DELETE hr_s_wc_state_surcharges;
608: COMMIT;
609:
610: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_RULES',NULL);
611: DELETE hr_s_legislation_rules;
612: COMMIT;
613:
614: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_TAXABILITY_RULES_DATES',NULL);
615: DELETE HR_S_TAXABILITY_RULES_DATES;

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

799:
800: BEGIN
801: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',10);
802: --Legislation Rules
803: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE','Legislation Rules', 'HR_S_LEGISLATION_RULES');
804:
805: INSERT INTO hr_s_application_ownerships
806: (key_name
807: ,product_name

Line 1778: INSERT INTO hr_s_legislation_rules

1774:
1775: BEGIN
1776: hr_utility.set_location('pay_ip_startup_util.create_flex_leg_rule ',10);
1777:
1778: INSERT INTO hr_s_legislation_rules
1779: ( legislation_code
1780: ,rule_type
1781: ,rule_mode)
1782: SELECT

Line 1788: FROM hr_s_legislation_rules

1784: ,p_rule_type
1785: ,p_rule_mode
1786: FROM dual
1787: WHERE NOT EXISTS (SELECT NULL
1788: FROM hr_s_legislation_rules
1789: WHERE legislation_code = 'ZZ'
1790: AND rule_type = p_rule_type);
1791: IF SQL%NOTFOUND THEN
1792: UPDATE hr_s_legislation_rules SET

Line 1792: UPDATE hr_s_legislation_rules SET

1788: FROM hr_s_legislation_rules
1789: WHERE legislation_code = 'ZZ'
1790: AND rule_type = p_rule_type);
1791: IF SQL%NOTFOUND THEN
1792: UPDATE hr_s_legislation_rules SET
1793: rule_mode = p_rule_mode
1794: WHERE legislation_code = 'ZZ'
1795: AND rule_type = p_rule_type;
1796: END IF;

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

1837: WHERE legislation_code = 'ZZ';
1838:
1839: --Updating Legislation Rules Table
1840:
1841: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATION_RULES',NULL);
1842: UPDATE hr_s_legislation_rules
1843: SET legislation_code = p_legislation_code
1844: WHERE legislation_code = 'ZZ';
1845:

Line 1842: UPDATE hr_s_legislation_rules

1838:
1839: --Updating Legislation Rules Table
1840:
1841: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATION_RULES',NULL);
1842: UPDATE hr_s_legislation_rules
1843: SET legislation_code = p_legislation_code
1844: WHERE legislation_code = 'ZZ';
1845:
1846: --Unpadting Legislative Field Info