APPS.HR_PERSON_RECORD dependencies on PER_CONTACT_RELATIONSHIPS

Line 540: FROM PER_CONTACT_RELATIONSHIPS PCR

536: , CONT_INFORMATION17
537: , CONT_INFORMATION18
538: , CONT_INFORMATION19
539: , CONT_INFORMATION20
540: FROM PER_CONTACT_RELATIONSHIPS PCR
541: where PCR.PERSON_ID = p_person_id
542: and PCR.business_group_id = p_business_group_id
543: and p_eff_date between DATE_START and nvl(date_end,to_date('31/12/4712','DD/MM/YYYY') );
544:

Line 615: FROM PER_ADDRESSES PA, PER_CONTACT_RELATIONSHIPS PCR

611: , PA.PARTY_ID
612: , DERIVED_LOCALE
613: , GEOMETRY
614: , PA.COMMENTS
615: FROM PER_ADDRESSES PA, PER_CONTACT_RELATIONSHIPS PCR
616: WHERE PCR.PERSON_ID = p_person_id
617: AND PCR.CONTACT_PERSON_ID = PA.PERSON_ID
618: and p_eff_date between PCR.DATE_START and nvl(PCR.date_end,to_date('31/12/4712','DD/MM/YYYY'))
619: and p_eff_date between pa.date_from and nvl(pa.date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line 1207: FROM PER_CONTACT_RELATIONSHIPS PCR

1203: , CEI_ATTRIBUTE19
1204: , CEI_ATTRIBUTE20
1205: FROM PER_CONTACT_EXTRA_INFO_F
1206: WHERE CONTACT_RELATIONSHIP_ID in (SELECT PCR.CONTACT_RELATIONSHIP_ID
1207: FROM PER_CONTACT_RELATIONSHIPS PCR
1208: where PCR.PERSON_ID = p_person_id
1209: and PCR.business_group_id = p_business_group_id
1210: and p_eff_date between DATE_START and nvl(date_end,to_date('31/12/4712','DD/MM/YYYY') ));
1211:

Line 1497: from per_contact_relationships pcr

1493: and pgm.business_group_id = p_business_group_id) Program_Name,
1494: ppf.first_name||' '||ppf.last_name || ' ' || ppf.suffix Dependent,
1495: ppf.national_identifier Ssn,
1496: (select HR_GENERAL.DECODE_LOOKUP('CONTACT',pcr.contact_type)
1497: from per_contact_relationships pcr
1498: where pcr.personal_flag = 'Y'
1499: and pcr.person_id = pen.person_id
1500: and pcr.contact_person_id = pdp.dpnt_person_id
1501: and p_effective_date between nvl(pcr.date_start, p_effective_date )

Line 1505: from per_contact_relationships pcr2

1501: and p_effective_date between nvl(pcr.date_start, p_effective_date )
1502: and nvl(pcr.date_end, p_effective_date )
1503: and decode(pcr.contact_type,'S',1,'D',2,'A',3,'C',4,'O',5,'T',6,'P',7,8) <=
1504: (select decode(pcr2.contact_type,'S',1,'D',2,'A',3,'C',4,'O',5,'T',6,'P',7,8)
1505: from per_contact_relationships pcr2
1506: where pcr2.person_id = pcr.person_id
1507: and pcr2.contact_person_id = pcr.contact_person_id
1508: and p_effective_date between nvl(pcr2.date_start, p_effective_date )
1509: and nvl(pcr2.date_end, p_effective_date )

Line 1523: per_contact_relationships pcr,

1519: to_date(null) cvg_thru_dt
1520: from ben_elig_per_elctbl_chc epe,
1521: ben_prtt_enrt_rslt_f pen,
1522: ben_elig_cvrd_dpnt_f pdp,
1523: per_contact_relationships pcr,
1524: per_people_f ppf,
1525: ben_pl_typ_f plt,
1526: ben_pl_f pln,
1527: ben_opt_f opt,

Line 1616: per_contact_relationships pcr,

1612: pen.pl_ordr_num pl_ordr_num,
1613: pen.oipl_ordr_num oipl_ordr_num,
1614: pen.bnft_ordr_num bnft_ordr_num
1615: from per_people_f ppf,
1616: per_contact_relationships pcr,
1617: ben_prtt_enrt_rslt_f pen,
1618: ben_pl_bnf_f pbn,
1619: ben_pl_typ_f plt,
1620: ben_pl_f pln,

Line 1689: from per_contact_relationships pcr2

1685: (p_effective_date between
1686: nvl(pcr.date_start, p_effective_date ) and
1687: nvl(pcr.date_end, p_effective_date )) or
1688: ((pcr.date_start = (select max(pcr2.date_start)
1689: from per_contact_relationships pcr2
1690: where pcr2.contact_person_id = pcr.contact_person_id
1691: and pcr2.person_id = pcr.person_id
1692: and pcr2.personal_flag = 'Y')) and
1693: not exists (select null

Line 1694: from PER_CONTACT_RELATIONSHIPS pcr3

1690: where pcr2.contact_person_id = pcr.contact_person_id
1691: and pcr2.person_id = pcr.person_id
1692: and pcr2.personal_flag = 'Y')) and
1693: not exists (select null
1694: from PER_CONTACT_RELATIONSHIPS pcr3
1695: where pcr3.contact_person_id = pcr.contact_person_id
1696: and pcr3.person_id = pcr.person_id
1697: and pcr3.personal_flag = 'Y'
1698: and p_effective_date between