APPS.HR_DATE_CHK dependencies on PAY_COST_ALLOCATIONS_F

Line 141: from pay_cost_allocations_f cost

137: for update of effective_start_date;
138: --
139: cursor cost is
140: select 'cost'
141: from pay_cost_allocations_f cost
142: where assignment_id in (select a.assignment_id
143: from per_assignments_f a
144: where person_id = p_person_id
145: and a.assignment_type = 'E')

Line 441: from PAY_COST_ALLOCATIONS_F ca,

437: select 1
438: into v_dummy
439: from sys.dual
440: where exists (select 1
441: from PAY_COST_ALLOCATIONS_F ca,
442: per_periods_of_service p,
443: per_assignments_f a
444: where a.person_id = p_person_id
445: and a.period_of_service_id = p_period_of_service_id

Line 737: from PAY_COST_ALLOCATIONS_F pca

733: and sp.effective_start_date = p_s_start_date;
734: --
735: cursor cost is
736: select COST_ALLOCATION_ID
737: from PAY_COST_ALLOCATIONS_F pca
738: where assignment_id in (select a.assignment_id
739: from per_assignments_f a
740: where person_id = p_person_id
741: and a.assignment_type = 'E'

Line 815: update PAY_COST_ALLOCATIONS_F

811: open cost;
812: loop
813: fetch cost into l_ca_id;
814: exit when cost%NOTFOUND;
815: update PAY_COST_ALLOCATIONS_F
816: set effective_start_date = p_start_date
817: where effective_start_date = p_s_start_date
818: and COST_ALLOCATION_ID = l_ca_id;
819: if sql%rowcount <1 then

Line 821: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');

817: where effective_start_date = p_s_start_date
818: and COST_ALLOCATION_ID = l_ca_id;
819: if sql%rowcount <1 then
820: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
821: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
822: hr_utility.raise_error;
823: end if;
824: end loop;
825: close cost;