APPS.BEN_ASSIGNMENT_INTERNAL dependencies on PER_ALL_PEOPLE_F

Line 310: l_prior_marital_status per_all_people_f.marital_status%type;

306: l_act_pos varchar2(1);
307: l_exists boolean default false;
308: lc_effective_date date;
309: l_type_exist varchar2(1) ;
310: l_prior_marital_status per_all_people_f.marital_status%type;
311: --
312: cursor c_getbgpdets
313: (c_person_id in number
314: ,c_effective_date in date

Line 321: per_all_people_f per,

317: select bgp.business_group_id,
318: bgp.legislation_code,
319: pet.system_person_type
320: from per_business_groups bgp,
321: per_all_people_f per,
322: per_person_types pet
323: where per.business_group_id = bgp.business_group_id
324: and per.person_type_id = pet.person_type_id
325: and per.person_id = c_person_id

Line 526: from per_all_people_f

522: between ptu.effective_start_date and ptu.effective_end_date;
523: --
524: cursor c1 is
525: select business_group_id
526: from per_all_people_f
527: where person_id = p_person_id;
528: --
529: cursor c_get_prior_marital_status is
530: select per.marital_status

Line 531: from per_all_people_f per

527: where person_id = p_person_id;
528: --
529: cursor c_get_prior_marital_status is
530: select per.marital_status
531: from per_all_people_f per
532: where per.person_id = p_person_id
533: and p_per_esd - 1
534: between per.effective_start_date and per.effective_end_date;
535: ---

Line 2181: from per_all_people_f per,

2177: per.original_date_of_hire,
2178: pds.actual_termination_date,
2179: pds.leaving_reason,
2180: pds.date_start
2181: from per_all_people_f per,
2182: per_periods_of_service pds
2183: where per.person_id = c_person_id
2184: and per.person_id = pds.person_id
2185: and c_eff_date