eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on PER_CONTACT_RELATIONSHIPS

Line 427: from per_contact_relationships

423: and lcc.effective_end_date
424: and (lcc.rlshp_typ_cd is null
425: or
426: lcc.rlshp_typ_cd in (select contact_type
427: from per_contact_relationships
428: where contact_person_id = p_dpnt_person_id
429: and person_id = p_person_id
430: and business_group_id = p_business_group_id
431: and p_effective_date

Line 446: from per_contact_relationships

442: and effective_end_date
443: and (rlshp_typ_cd is null
444: or
445: rlshp_typ_cd in (select contact_type
446: from per_contact_relationships
447: where contact_person_id = p_dpnt_person_id
448: and person_id = p_person_id
449: and business_group_id = p_business_group_id
450: and p_effective_date

Line 464: from per_contact_relationships

460: and effective_end_date
461: and (rlshp_typ_cd is null
462: or
463: rlshp_typ_cd in (select contact_type
464: from per_contact_relationships
465: where contact_person_id = p_dpnt_person_id
466: and person_id = p_person_id
467: and business_group_id = p_business_group_id
468: and p_effective_date

Line 482: from per_contact_relationships

478: and effective_end_date
479: and (rlshp_typ_cd is null
480: or
481: rlshp_typ_cd in (select contact_type
482: from per_contact_relationships
483: where contact_person_id = p_dpnt_person_id
484: and person_id = p_person_id
485: and business_group_id = p_business_group_id
486: and p_effective_date

Line 2678: l_rsds per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%type;

2674: -- zip code. If person does not reside with participant do they have a
2675: -- primary address and a valid zip code.
2676: --
2677: l_proc varchar2(80) ;
2678: l_rsds per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%type;
2679: l_valid_adrs boolean;
2680: --
2681: -- Cursor to check if person resides with participant
2682: --

Line 2685: from per_contact_relationships pcr, ben_prtt_enrt_rslt_f perslt

2681: -- Cursor to check if person resides with participant
2682: --
2683: cursor c_rsds is
2684: select pcr.rltd_per_rsds_w_dsgntr_flag
2685: from per_contact_relationships pcr, ben_prtt_enrt_rslt_f perslt
2686: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2687: and perslt.person_id = pcr.person_id
2688: and pcr.contact_person_id = p_dpnt_bnf_person_id
2689: and pcr.business_group_id = p_business_group_id

Line 3313: from per_contact_relationships

3309: and lcc.effective_end_date
3310: and (lcc.rlshp_typ_cd is null
3311: or
3312: lcc.rlshp_typ_cd in (select contact_type
3313: from per_contact_relationships
3314: where contact_person_id = v_dpnt_person_id
3315: and person_id = v_person_id
3316: and business_group_id = p_business_group_id
3317: and p_effective_date

Line 3337: from per_contact_relationships

3333: and pl.effective_end_date
3334: and (pl.rlshp_typ_cd is null
3335: or
3336: pl.rlshp_typ_cd in (select contact_type
3337: from per_contact_relationships
3338: where contact_person_id = v_dpnt_person_id
3339: and person_id = v_person_id
3340: and business_group_id = p_business_group_id
3341: and p_effective_date

Line 3361: from per_contact_relationships

3357: and pgm.effective_end_date
3358: and (pgm.rlshp_typ_cd is null
3359: or
3360: pgm.rlshp_typ_cd in (select contact_type
3361: from per_contact_relationships
3362: where contact_person_id = v_dpnt_person_id
3363: and person_id = v_person_id
3364: and business_group_id = p_business_group_id
3365: and p_effective_date

Line 3386: from per_contact_relationships

3382: and ptip.effective_end_date
3383: and (ptip.rlshp_typ_cd is null
3384: or
3385: ptip.rlshp_typ_cd in (select contact_type
3386: from per_contact_relationships
3387: where contact_person_id = v_dpnt_person_id
3388: and person_id = v_person_id
3389: and business_group_id = p_business_group_id
3390: and p_effective_date

Line 5142: per_contact_relationships pcr,

5138: and perslt.effective_end_date
5139: and mn_dpnts_rqd_num >
5140: (select count(1)
5141: from ben_elig_cvrd_dpnt_f ecd,
5142: per_contact_relationships pcr,
5143: ben_per_in_ler pil
5144: where ecd.prtt_enrt_rslt_id = perslt.prtt_enrt_rslt_id
5145: and ecd.cvg_strt_dt is not null
5146: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 7650: from per_contact_relationships

7646: where pl.bnf_ctfn_typ_cd <> 'NSC'
7647: and pl.pl_id = v_pl_id
7648: and (pl.rlshp_typ_cd is null or
7649: pl.rlshp_typ_cd in (select contact_type
7650: from per_contact_relationships
7651: where contact_person_id = v_bnf_person_id
7652: and person_id = v_person_id
7653: and business_group_id = p_business_group_id
7654: and p_effective_date

Line 7698: from per_contact_relationships

7694: and (bnf_typ_cd is null or bnf_typ_cd = 'P')
7695: and (rlshp_typ_cd is null
7696: or
7697: rlshp_typ_cd in (select contact_type
7698: from per_contact_relationships
7699: where contact_person_id = v_bnf_person_id
7700: and person_id = v_person_id
7701: and business_group_id = p_business_group_id
7702: and p_effective_date

Line 8828: per_contact_relationships pcr,

8824: plb.bnf_person_id,
8825: plb.pl_bnf_id,
8826: pl.pl_id
8827: from per_all_people_f per,
8828: per_contact_relationships pcr,
8829: ben_pl_f pl,
8830: ben_pl_bnf_f plb,
8831: ben_prtt_enrt_rslt_f pen,
8832: ben_per_in_ler pil