APPS.HR_DATE_CHK dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 80: 110.5 8-MAY-1998 SASmith Due to the date tracking of per_assignment_budget_values_f.

76: 110.3 06-nov-97 achauhan Added the update of the tax tables in the
77: update_hire_records, in case of 'US Payroll'
78: installed and change in hire date.
79:
80: 110.5 8-MAY-1998 SASmith Due to the date tracking of per_assignment_budget_values_f.
81: Add the update to this table in case there are changes in the
82: hire date then there will be a required change in the
83: assignment budget values.
84:

Line 760: from PER_ASSIGNMENT_BUDGET_VALUES_F abv

756: and rownum < 2;
757: --
758: cursor abv is
759: select ASSIGNMENT_BUDGET_VALUE_ID
760: from PER_ASSIGNMENT_BUDGET_VALUES_F abv
761: where assignment_id in (select a.assignment_id
762: from per_assignments_f a
763: where person_id = p_person_id
764: and a.assignment_type = 'E'

Line 844: update PER_ASSIGNMENT_BUDGET_VALUES_F

840: loop
841: fetch abv into l_abv_id;
842: exit when abv%NOTFOUND;
843:
844: update PER_ASSIGNMENT_BUDGET_VALUES_F
845: set effective_start_date = p_start_date
846: where effective_start_date = p_s_start_date
847: and effective_end_date >= p_start_date
848: and ASSIGNMENT_BUDGET_VALUE_ID = l_abv_id;