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)