APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_CONTACT_RELATIONSHIPS

Line 132: are present for dependent in per_contact_relationships table.

128: * 05-Feb-09 krupani 115.61 7718592 - Reverted back fix against 5908080
129: * 27-Sep-12 usaraswa 115.62 14552686 - when dependent enrollment record(other than coverage thru date) is
130: overrided through enrollment override form then dependent coverage is not ending though the dependent became ineligible.
131: 10-Dec-12 usaraswa 115.63 14775822 - Modified cursor c_designation to fetch only one row though multiple rows
132: are present for dependent in per_contact_relationships table.
133: * -----------------------------------------------------------------------------
134: */
135: --
136: -- Global cursor and variables declaration

Line 1239: per_contact_relationships ctr

1235: ecd.per_in_ler_id
1236: From ben_prtt_enrt_rslt_f pen,
1237: ben_elig_cvrd_dpnt_f ecd,
1238: ben_per_in_ler pil,
1239: per_contact_relationships ctr
1240: Where pen.business_group_id = p_business_group_id
1241: and pen.prtt_enrt_rslt_stat_cd is null
1242: and ecd.dpnt_person_id = p_person_id
1243: and (nvl(ecd.ovrdn_flag,'N')='N' or

Line 1263: FROM per_contact_relationships

1259: and ctr.business_group_id=p_business_group_id
1260: and ctr.contact_person_id=p_person_id
1261: --Bug 14775822
1262: and ctr.date_start in (SELECT max (date_start)
1263: FROM per_contact_relationships
1264: WHERE contact_person_id = p_person_id
1265: AND person_id = pen.person_id
1266: AND personal_flag = 'Y'
1267: AND business_group_id = p_business_group_id