APPS.HR_LEGISLATION_LOCAL dependencies on PAY_LEGISLATION_RULES

Line 728: -- INSTALLATION PROCEDURE FOR : PAY_LEGISLATION_RULES

724:
725: END install_surcharges;
726:
727: --****************************************************************************
728: -- INSTALLATION PROCEDURE FOR : PAY_LEGISLATION_RULES
729: --****************************************************************************
730:
731: PROCEDURE install_leg_rules(p_phase IN number)
732: ----------------------------------------------

Line 805: from pay_legislation_rules

801: END;
802:
803: select rule_mode
804: into l_rule_mode
805: from pay_legislation_rules
806: where rule_type = stu_rec.rule_type
807: and legislation_code = stu_rec.legislation_code;
808:
809: IF l_rule_mode = l_hrs_rule_mode THEN

Line 823: update pay_legislation_rules

819: IF p_phase = 1 THEN --only update in phase 2
820: return;
821: END IF;
822:
823: update pay_legislation_rules
824: set rule_mode = l_hrs_rule_mode
825: where rule_type = stu_rec.rule_type
826: and legislation_code = stu_rec.legislation_code;
827:

Line 837: insert into pay_legislation_rules

833: IF p_phase = 1 THEN
834: return;
835: END IF;
836:
837: insert into pay_legislation_rules
838: (legislation_code
839: ,rule_mode
840: ,rule_type
841: )

Line 2425: delete from pay_legislation_rules

2421: hr_utility.trace('start gb scl flex delete: ' || to_char(p_phase));
2422: hr_legislation.hrrunprc_trace_off;
2423:
2424: --the gb scl flex only needs to appear at payroll sites
2425: delete from pay_legislation_rules
2426: where legislation_code = 'GB'
2427: and rule_type = 'S'
2428: and not exists
2429: (select null