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 414: from per_contact_relationships

410: and lcc.effective_end_date
411: and (lcc.rlshp_typ_cd is null
412: or
413: lcc.rlshp_typ_cd in (select contact_type
414: from per_contact_relationships
415: where contact_person_id = p_dpnt_person_id
416: and person_id = p_person_id
417: and business_group_id = p_business_group_id
418: and p_effective_date

Line 433: from per_contact_relationships

429: and effective_end_date
430: and (rlshp_typ_cd is null
431: or
432: rlshp_typ_cd in (select contact_type
433: from per_contact_relationships
434: where contact_person_id = p_dpnt_person_id
435: and person_id = p_person_id
436: and business_group_id = p_business_group_id
437: and p_effective_date

Line 451: from per_contact_relationships

447: and effective_end_date
448: and (rlshp_typ_cd is null
449: or
450: rlshp_typ_cd in (select contact_type
451: from per_contact_relationships
452: where contact_person_id = p_dpnt_person_id
453: and person_id = p_person_id
454: and business_group_id = p_business_group_id
455: and p_effective_date

Line 469: from per_contact_relationships

465: and effective_end_date
466: and (rlshp_typ_cd is null
467: or
468: rlshp_typ_cd in (select contact_type
469: from per_contact_relationships
470: where contact_person_id = p_dpnt_person_id
471: and person_id = p_person_id
472: and business_group_id = p_business_group_id
473: and p_effective_date

Line 2665: l_rsds per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%type;

2661: -- zip code. If person does not reside with participant do they have a
2662: -- primary address and a valid zip code.
2663: --
2664: l_proc varchar2(80) ;
2665: l_rsds per_contact_relationships.rltd_per_rsds_w_dsgntr_flag%type;
2666: l_valid_adrs boolean;
2667: --
2668: -- Cursor to check if person resides with participant
2669: --

Line 2672: from per_contact_relationships pcr, ben_prtt_enrt_rslt_f perslt

2668: -- Cursor to check if person resides with participant
2669: --
2670: cursor c_rsds is
2671: select pcr.rltd_per_rsds_w_dsgntr_flag
2672: from per_contact_relationships pcr, ben_prtt_enrt_rslt_f perslt
2673: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2674: and perslt.person_id = pcr.person_id
2675: and pcr.contact_person_id = p_dpnt_bnf_person_id
2676: and pcr.business_group_id = p_business_group_id

Line 3300: from per_contact_relationships

3296: and lcc.effective_end_date
3297: and (lcc.rlshp_typ_cd is null
3298: or
3299: lcc.rlshp_typ_cd in (select contact_type
3300: from per_contact_relationships
3301: where contact_person_id = v_dpnt_person_id
3302: and person_id = v_person_id
3303: and business_group_id = p_business_group_id
3304: and p_effective_date

Line 3324: from per_contact_relationships

3320: and pl.effective_end_date
3321: and (pl.rlshp_typ_cd is null
3322: or
3323: pl.rlshp_typ_cd in (select contact_type
3324: from per_contact_relationships
3325: where contact_person_id = v_dpnt_person_id
3326: and person_id = v_person_id
3327: and business_group_id = p_business_group_id
3328: and p_effective_date

Line 3348: from per_contact_relationships

3344: and pgm.effective_end_date
3345: and (pgm.rlshp_typ_cd is null
3346: or
3347: pgm.rlshp_typ_cd in (select contact_type
3348: from per_contact_relationships
3349: where contact_person_id = v_dpnt_person_id
3350: and person_id = v_person_id
3351: and business_group_id = p_business_group_id
3352: and p_effective_date

Line 3373: from per_contact_relationships

3369: and ptip.effective_end_date
3370: and (ptip.rlshp_typ_cd is null
3371: or
3372: ptip.rlshp_typ_cd in (select contact_type
3373: from per_contact_relationships
3374: where contact_person_id = v_dpnt_person_id
3375: and person_id = v_person_id
3376: and business_group_id = p_business_group_id
3377: and p_effective_date

Line 5127: per_contact_relationships pcr,

5123: and perslt.effective_end_date
5124: and mn_dpnts_rqd_num >
5125: (select count(1)
5126: from ben_elig_cvrd_dpnt_f ecd,
5127: per_contact_relationships pcr,
5128: ben_per_in_ler pil
5129: where ecd.prtt_enrt_rslt_id = perslt.prtt_enrt_rslt_id
5130: and ecd.cvg_strt_dt is not null
5131: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 7565: from per_contact_relationships

7561: where pl.bnf_ctfn_typ_cd <> 'NSC'
7562: and pl.pl_id = v_pl_id
7563: and (pl.rlshp_typ_cd is null or
7564: pl.rlshp_typ_cd in (select contact_type
7565: from per_contact_relationships
7566: where contact_person_id = v_bnf_person_id
7567: and person_id = v_person_id
7568: and business_group_id = p_business_group_id
7569: and p_effective_date

Line 7613: from per_contact_relationships

7609: and (bnf_typ_cd is null or bnf_typ_cd = 'P')
7610: and (rlshp_typ_cd is null
7611: or
7612: rlshp_typ_cd in (select contact_type
7613: from per_contact_relationships
7614: where contact_person_id = v_bnf_person_id
7615: and person_id = v_person_id
7616: and business_group_id = p_business_group_id
7617: and p_effective_date

Line 8743: per_contact_relationships pcr,

8739: plb.bnf_person_id,
8740: plb.pl_bnf_id,
8741: pl.pl_id
8742: from per_all_people_f per,
8743: per_contact_relationships pcr,
8744: ben_pl_f pl,
8745: ben_pl_bnf_f plb,
8746: ben_prtt_enrt_rslt_f pen,
8747: ben_per_in_ler pil