APPS.BEN_DETERMINE_DATE dependencies on PER_ALL_PEOPLE_F

Line 194: from per_all_people_f

190:
191: cursor c_national_identifier
192: is
193: select national_identifier
194: from per_all_people_f
195: where person_id=p_person_id;
196:
197:
198: l_message_name1 varchar2(500) := 'BEN_94441_ENROL_ST_DT_RANGE';

Line 209: l_national_identifier per_all_people_f.national_identifier%type;

205: l_pgm_name ben_pgm_f.name%type;
206: l_pl_name ben_pl_f.name%type;
207: l_opt_name ben_opt_f.name%type;
208: l_dummy number;
209: l_national_identifier per_all_people_f.national_identifier%type;
210:
211: begin
212: hr_utility.set_location('Entering validate_rule_cd_date',1000);
213:

Line 1064: from per_all_people_f paf

1060: and ecd.effective_end_date;
1061:
1062: cursor c_birth_date is
1063: select paf.date_of_birth
1064: from per_all_people_f paf
1065: where paf.person_id = p_person_id;
1066: --
1067: cursor c_ler_id is
1068: select pil.ler_id