DBA Data[Home] [Help]

APPS.PAY_MAGTAPE_EXTRACT dependencies on PAY_STATE_RULES

Line 130: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;

126: -- jurisdiction_code Jurisdiction code
127: -- legislative_parameters Legislative parameters
128: --==============================================================================
129: PROCEDURE arch_initialise (p_payroll_action_id NUMBER) IS
130: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;
131: legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
132: BEGIN
133: hr_utility.set_location ('arch_initialise',1);
134: --

Line 210: FROM pay_state_rules sr

206: --------------------------------------------------------------------------------
207: IF l_state <> 'FED' THEN
208: SELECT sr.jurisdiction_code
209: INTO jurisdiction_code
210: FROM pay_state_rules sr
211: WHERE sr.state_code = l_state;
212: --
213: pay_balance_pkg.set_context ('JURISDICTION_CODE',jurisdiction_code);
214: END IF;