DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY3 dependencies on PER_ALL_PEOPLE_F

Line 51: per_all_people_f ppf

47: cursor c_dsgn_rl_typ(p_mn_dpnts_rqd_num in number
48: ,p_dsgn_rqmt_id in number) is
49: select null
50: from per_contact_relationships ctr,
51: per_all_people_f ppf
52: where ctr.person_id = p_person_id
53: and ctr.personal_flag = 'Y'
54: and nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt, p_effective_date))
55: between nvl(ctr.date_start, hr_api.g_sot)