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 488: per_all_people_f per

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

Line 521: per_all_people_f per,

517: ctr.date_end, -- 4697057 Added this
518: 'N' contact_active_flag,
519: per.date_of_death /* Bug 7481099 */
520: from per_contact_relationships ctr,
521: per_all_people_f per,
522: ben_elig_cvrd_dpnt_f pdp,
523: ben_per_in_ler pil
524: where per.person_id = ctr.contact_person_id
525: -- and l_lf_evt_ocrd_dt <= nvl(per.DATE_OF_DEATH, l_lf_evt_ocrd_dt) /* Bug 4287999 */

Line 542: per_all_people_f per1

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