APPS.HR_DATE_CHK dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 132: from per_spinal_point_placements_f sp

128: for update of pa.assignment_id;
129: --
130: cursor ssp is
131: select 'ssp'
132: from per_spinal_point_placements_f sp
133: where assignment_id in (select a.assignment_id
134: from per_assignments_f a
135: where person_id = p_person_id
136: and a.assignment_type = 'E')

Line 409: from per_spinal_point_placements_f sp,

405: select 1
406: into v_dummy
407: from sys.dual
408: where exists (select 1
409: from per_spinal_point_placements_f sp,
410: per_periods_of_service p,
411: per_assignments_f a
412: where a.person_id = p_person_id
413: and a.period_of_service_id = p_period_of_service_id

Line 727: from per_spinal_point_placements_f sp

723: and peo.current_applicant_flag = 'Y');
724: --
725: cursor ssp is
726: select placement_id
727: from per_spinal_point_placements_f sp
728: where assignment_id in (select a.assignment_id
729: from per_assignments_f a
730: where person_id = p_person_id
731: and a.assignment_type = 'E'

Line 796: update per_spinal_point_placements_f

792: open ssp;
793: loop
794: fetch ssp into l_sp_id;
795: exit when ssp%NOTFOUND;
796: update per_spinal_point_placements_f
797: set effective_start_date = p_start_date
798: where effective_start_date = p_s_start_date
799: and placement_id = l_sp_id;
800: if sql%rowcount <1 then

Line 802: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');

798: where effective_start_date = p_s_start_date
799: and placement_id = l_sp_id;
800: if sql%rowcount <1 then
801: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
802: hr_utility.set_message_token('TABLE','PER_SPINAL_POINT_PLACEMENTS_F');
803: hr_utility.raise_error;
804: end if;
805: end loop;
806: close ssp;