APPS.HR_LEGISLATION_LOCAL dependencies on PAY_STATE_RULES

Line 27: -- PAY_STATE_RULES table installation

23: -- 70.8 Ian Carline 04-Aug-1994 - Added GB specific logic to delete
24: -- from some control tables when payroll
25: -- is not installed.
26: -- 70.9 Rod Fine 06-Oct-1994 - Added column FS_LOOKUP_TYPE to
27: -- PAY_STATE_RULES table installation
28: -- procedure.
29: -- 70.10 Rod Fine 23-Mar-1995 - Added column CLASSIFICATION_ID to
30: -- PAY_TAXABILITY_RULES table
31: -- installation procedure.

Line 35: -- 70.12 rfine 27-Mar-96 353225 When delivering PAY_STATE_RULES, update

31: -- installation procedure.
32: -- 70.11 Rod Fine 07-Apr-1995 - Added extra check on classification_id
33: -- to PAY_TAXABILITY_RULES transfer_row
34: -- procedure.
35: -- 70.12 rfine 27-Mar-96 353225 When delivering PAY_STATE_RULES, update
36: -- the row if it already exists, rather
37: -- than simply not delivering it.
38: -- 70.12 M. Stewart 23-Sep-1996 - Updated table names from STU_ to HR_S_
39: -- 70.13 Tim Eyres 02-Jan-1997 - Moved arcs header to directly after

Line 146: -- INSTALLATION PROCEDURE FOR : PAY_STATE_RULES

142:
143: driving_legislation varchar2(30);
144:
145: --****************************************************************************
146: -- INSTALLATION PROCEDURE FOR : PAY_STATE_RULES
147: --****************************************************************************
148:
149: PROCEDURE install_state_rules(p_phase IN number)
150: ------------------------------------------------

Line 154: -- The object PAY_STATE_RULES is used only in the US payroll system

150: ------------------------------------------------
151: IS
152: -- Install procedure to transfer startup state tax rules into the live
153: -- tables. This routine is written purely for the US localization team.
154: -- The object PAY_STATE_RULES is used only in the US payroll system
155:
156: l_null_return varchar2(1); -- For 'select null' statements
157: l_new_surrogate_key number(15); -- New surrogate key for the delivery row
158:

Line 214: update pay_state_rules

210: -- US Pay - previously the code wouldn't handle updates - it
211: -- only inserted new rows. RMF 27-Mar-96.
212: --
213:
214: update pay_state_rules
215: set FIPS_CODE = stu_rec.FIPS_CODE
216: , NAME = stu_rec.NAME
217: , JURISDICTION_CODE = stu_rec.JURISDICTION_CODE
218: , HEAD_TAX_PERIOD = stu_rec.HEAD_TAX_PERIOD

Line 232: insert into pay_state_rules

228:
229: -- Row does not exist so insert
230:
231:
232: insert into pay_state_rules
233: (STATE_CODE
234: ,FIPS_CODE
235: ,NAME
236: ,JURISDICTION_CODE

Line 2385: install_state_rules(p_phase); --install pay_state_rules

2381: hr_legislation.hrrunprc_trace_on;
2382: hr_utility.trace('start install_state_rules: ' || to_char(p_phase));
2383: hr_legislation.hrrunprc_trace_off;
2384:
2385: install_state_rules(p_phase); --install pay_state_rules
2386:
2387: hr_legislation.hrrunprc_trace_on;
2388: hr_utility.trace('start install_tax_rules: ' || to_char(p_phase));
2389: hr_legislation.hrrunprc_trace_off;