APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on PER_ALL_PEOPLE_F

Line 73: 30 Nov 99 lmcdonal 115.28 add per_all_people_f to c_contact

69: 07 Sep 99 jcarpent 115.25 Removed qmcso check.
70: 11 Oct 99 jcarpent 115.26 Added bg_id to update_elig_cvrd_dpn
71: 19 Nov 99 pbodla 115.27 Passed p_elig_per_elctbl_chc_id
72: to formula
73: 30 Nov 99 lmcdonal 115.28 add per_all_people_f to c_contact
74: cursor to avoid error in bendpelg.
75: 03 Jan 00 maagrawa 115.29 Added pl_typ_id to comm. process.
76: 07 Jan 00 pbodla 115.30 oabrules.xls says the ler_chg_dpnt_cvg_rl
77: should return Y/N.

Line 485: per_all_people_f per

481: ctr.contact_type,
482: ctr.date_end, -- 4697057 Added this
483: 'Y' contact_active_flag
484: from per_contact_relationships ctr,
485: per_all_people_f per
486: where per.person_id = ctr.contact_person_id
487: and l_lf_evt_ocrd_dt <= nvl(per.DATE_OF_DEATH, l_lf_evt_ocrd_dt) /* Bug 4287999 */
488: and l_lf_evt_ocrd_dt between per.effective_start_date and per.effective_end_date
489: and ctr.personal_flag = 'Y'

Line 517: per_all_people_f per,

513: ctr.contact_type,
514: ctr.date_end, -- 4697057 Added this
515: 'N' contact_active_flag
516: from per_contact_relationships ctr,
517: per_all_people_f per,
518: ben_elig_cvrd_dpnt_f pdp,
519: ben_per_in_ler pil
520: where per.person_id = ctr.contact_person_id
521: and l_lf_evt_ocrd_dt <= nvl(per.DATE_OF_DEATH, l_lf_evt_ocrd_dt) /* Bug 4287999 */

Line 538: per_all_people_f per1

534: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
535: and not exists (
536: select null
537: from per_contact_relationships ctr1,
538: per_all_people_f per1
539: where ctr1.contact_person_id=ctr.contact_person_id
540: and per1.person_id = ctr1.contact_person_id
541: and l_lf_evt_ocrd_dt between per1.effective_start_date and per1.effective_end_date
542: and ctr1.personal_flag = 'Y'