DBA Data[Home] [Help]

APPS.PER_PEOPLE4_PKG dependencies on PER_PEOPLE_F

Line 557: update per_people_f ppf

553: end if; -- End of HIRE.
554: end if; -- Of Person type change checks.
555: --
556: hr_utility.set_location('update_row - b4 update',1);
557: update per_people_f ppf
558: set ppf.person_id = p_person_id
559: ,ppf.effective_start_date = p_effective_start_date
560: ,ppf.effective_end_date = p_effective_end_date
561: ,ppf.business_group_id = p_business_group_id

Line 780: from per_people_f ppf

776: select '1'
777: from sys.dual
778: where exists (
779: select 'future assignment exists'
780: from per_people_f ppf
781: where ppf.person_id = p_person_id
782: and ppf.effective_start_date > p_effective_start_date
783: );
784: begin