APPS.BEN_DETERMINE_ELIGIBILITY dependencies on PER_CONTACT_RELATIONSHIPS

Line 112: l_ctr_rec per_contact_relationships%rowtype;

108: --
109: l_per_rec per_all_people_f%rowtype;
110: l_ass_rec per_all_assignments_f%rowtype;
111: l_loc_rec hr_locations_all%rowtype;
112: l_ctr_rec per_contact_relationships%rowtype;
113: l_hsc_rec hr_soft_coding_keyflex%rowtype;
114: l_org_rec hr_all_organization_units%rowtype;
115: l_loop_count number;
116: --

Line 128: from per_contact_relationships ctr,

124: l_fonm_cvg_strt_dt DATE ;
125: --END FONM
126: cursor c_get_contacts is
127: select ctr.*
128: from per_contact_relationships ctr,
129: per_all_people_f ppf
130: where ctr.person_id = p_person_id
131: and ctr.personal_flag = 'Y'
132: and ctr.contact_person_id = ppf.person_id

Line 143: from per_contact_relationships ctr,

139: and ctr.business_group_id = p_business_group_id;
140: --
141: cursor c_get_no_of_contacts is
142: select count(ctr.person_id)
143: from per_contact_relationships ctr,
144: per_all_people_f ppf
145: where ctr.person_id = p_person_id
146: and ctr.personal_flag = 'Y'
147: and ctr.contact_person_id = ppf.person_id