DBA Data[Home] [Help]

APPS.PER_PEOPLE4_PKG dependencies on PER_PEOPLE_F

Line 629: update per_people_f ppf

625: --
626: IF g_debug THEN
627: hr_utility.set_location(g_package || l_proc, 210);
628: END IF;
629: update per_people_f ppf
630: set ppf.person_id = p_person_id
631: ,ppf.effective_start_date = p_effective_start_date
632: ,ppf.effective_end_date = p_effective_end_date
633: ,ppf.business_group_id = p_business_group_id

Line 874: from per_people_f ppf

870: select '1'
871: from sys.dual
872: where exists (
873: select 'future assignment exists'
874: from per_people_f ppf
875: where ppf.person_id = p_person_id
876: and ppf.effective_start_date > p_effective_start_date
877: );
878: --