DBA Data[Home] [Help]

APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on PER_ALL_PEOPLE_F

Line 370: per_all_people_f ppf

366: pel.object_version_number
367: from ben_per_in_ler pil,
368: ben_ler_f ler,
369: ben_pil_elctbl_chc_popl pel,
370: per_all_people_f ppf
371: where pil.person_id = l_person_id
372: and pil.lf_evt_ocrd_dt = nvl(l_lf_evt_ocrd_dt,pil.lf_evt_ocrd_dt)
373: and pil.business_group_id+0 = p_business_group_id
374: and pil.ler_id = nvl(p_ler_id,pil.ler_id)

Line 865: from per_all_people_f ppf

861: -- Cursors declaration.
862: --
863: cursor c_person is
864: select ppf.person_id
865: from per_all_people_f ppf
866: where ppf.person_id = nvl(p_person_id, ppf.person_id)
867: and ppf.business_group_id = p_business_group_id
868: and l_effective_date
869: between ppf.effective_start_date

Line 912: from per_all_people_f pap

908: and paa.primary_flag = 'Y'
909: and paa.location_id = p_location_id))
910: and (p_benfts_grp_id is null
911: or exists (select null
912: from per_all_people_f pap
913: where pap.person_id = ppf.person_id
914: and pap.business_group_id = ppf.business_group_id
915: and l_effective_date
916: between pap.effective_start_date