DBA Data[Home] [Help]

APPS.PAY_US_TAX_INTERNAL dependencies on PER_US_EXTRA_ASSIGNMENT_RULES

Line 3566: -- per_us_extra_assignment_rules.g_old_assgt_location is set in the user

3562: -- is UPDATE_OVERRIDE and the location_id was passed as default value
3563: -- ie:hr_api.g_number. Reason for this is we should take the value of
3564: -- the location_id as of the effective date of the change and we must
3565: -- maintain the tax records. The value of
3566: -- per_us_extra_assignment_rules.g_old_assgt_location is set in the user
3567: -- hook (before) procedure to used for stored data.
3568: --
3569: if p_datetrack_mode = 'UPDATE_OVERRIDE' THEN
3570: l_location_id := per_us_extra_assignment_rules.g_old_assgt_location;

Line 3570: l_location_id := per_us_extra_assignment_rules.g_old_assgt_location;

3566: -- per_us_extra_assignment_rules.g_old_assgt_location is set in the user
3567: -- hook (before) procedure to used for stored data.
3568: --
3569: if p_datetrack_mode = 'UPDATE_OVERRIDE' THEN
3570: l_location_id := per_us_extra_assignment_rules.g_old_assgt_location;
3571: else
3572: l_location_id := p_location_id;
3573: end if;
3574: --

Line 4320: -- per_us_extra_assignment_rules.g_old_assgt_location. If the old location

4316: -- when we change the location on the assignment record and the location
4317: -- address resided in a different state.
4318: --
4319: -- bug 1168727 comparing the p_location_id to global
4320: -- per_us_extra_assignment_rules.g_old_assgt_location. If the old location
4321: -- id is same as the parameter location id then there is no need to update
4322: -- the tax records. PLEASE NOTE THAT THE GLOBAL IS DEFINE IN PACKAGE
4323: -- per_us_extra_assignment_rules AND SET IN PROCEDURE get_curr_ass_location_id.
4324: --

Line 4323: -- per_us_extra_assignment_rules AND SET IN PROCEDURE get_curr_ass_location_id.

4319: -- bug 1168727 comparing the p_location_id to global
4320: -- per_us_extra_assignment_rules.g_old_assgt_location. If the old location
4321: -- id is same as the parameter location id then there is no need to update
4322: -- the tax records. PLEASE NOTE THAT THE GLOBAL IS DEFINE IN PACKAGE
4323: -- per_us_extra_assignment_rules AND SET IN PROCEDURE get_curr_ass_location_id.
4324: --
4325: -- We will always attempt to process the location change is the date track
4326: -- mode is UPDATE_OVERRIDE.
4327: --

Line 4330: p_location_id = per_us_extra_assignment_rules.g_old_assgt_location then

4326: -- mode is UPDATE_OVERRIDE.
4327: --
4328: if p_datetrack_mode in ('CORRECTION', 'UPDATE',
4329: 'UPDATE_CHANGE_INSERT' ) and
4330: p_location_id = per_us_extra_assignment_rules.g_old_assgt_location then
4331: RAISE l_exit_quietly;
4332: end if;
4333: --
4334: if p_datetrack_mode in('CORRECTION', 'UPDATE',