APPS.BEN_ASSIGNMENT_INTERNAL dependencies on PER_ALL_PEOPLE_F

Line 516: l_prior_marital_status per_all_people_f.marital_status%type;

512: l_act_pos varchar2(1);
513: l_exists boolean default false;
514: lc_effective_date date;
515: l_type_exist varchar2(1) ;
516: l_prior_marital_status per_all_people_f.marital_status%type;
517: --
518: cursor c_getbgpdets
519: (c_person_id in number
520: ,c_effective_date in date

Line 527: per_all_people_f per,

523: select bgp.business_group_id,
524: bgp.legislation_code,
525: pet.system_person_type
526: from per_business_groups bgp,
527: per_all_people_f per,
528: per_person_types pet
529: where per.business_group_id = bgp.business_group_id
530: and per.person_type_id = pet.person_type_id
531: and per.person_id = c_person_id

Line 732: from per_all_people_f

728: between ptu.effective_start_date and ptu.effective_end_date;
729: --
730: cursor c1 is
731: select business_group_id
732: from per_all_people_f
733: where person_id = p_person_id;
734: --
735: cursor c_get_prior_marital_status is
736: select per.marital_status

Line 737: from per_all_people_f per

733: where person_id = p_person_id;
734: --
735: cursor c_get_prior_marital_status is
736: select per.marital_status
737: from per_all_people_f per
738: where per.person_id = p_person_id
739: and p_per_esd - 1
740: between per.effective_start_date and per.effective_end_date;
741: ---

Line 2293: from per_all_people_f per,

2289: per.original_date_of_hire,
2290: pds.actual_termination_date,
2291: pds.leaving_reason,
2292: pds.date_start
2293: from per_all_people_f per,
2294: per_periods_of_service pds
2295: where per.person_id = c_person_id
2296: and per.person_id = pds.person_id
2297: and c_eff_date