DBA Data[Home] [Help]

APPS.PER_ESA_BUS dependencies on PER_PEOPLE_F

Line 943: from per_people_f per

939: -- performance.
940:
941: cursor c1 is
942: select null
943: from per_people_f per
944: where per.person_id = p_person_id
945: and per.business_group_id =nvl(p_business_group_id,per.business_group_id)
946: and trunc(p_effective_date)
947: between trunc(per.effective_start_date)

Line 962: -- check if the person exists in the per_people_f table for the same

958: if (l_api_updating
959: and nvl(p_person_id,hr_api.g_number) <> per_esa_shd.g_old_rec.person_id
960: or not l_api_updating) then
961: --
962: -- check if the person exists in the per_people_f table for the same
963: -- business group
964: --
965: open c1;
966: --