APPS.PER_ES_ABSENCE dependencies on PER_PEOPLE_F

Line 391: FROM per_people_f ppf

387: --
388:
389: CURSOR csr_validate_sex_par(p_person_id NUMBER) IS
390: SELECT ppf.sex
391: FROM per_people_f ppf
392: WHERE ppf.person_id = p_person_id ;
393:
394: l_sex per_people_f.sex%TYPE;
395:

Line 394: l_sex per_people_f.sex%TYPE;

390: SELECT ppf.sex
391: FROM per_people_f ppf
392: WHERE ppf.person_id = p_person_id ;
393:
394: l_sex per_people_f.sex%TYPE;
395:
396: l_maternity_benefit_days NUMBER;
397: l_absence_category per_absence_attendance_types.absence_category%TYPE;
398: --

Line 642: FROM per_people_f ppf

638: --
639:
640: CURSOR csr_validate_sex_par(p_person_id NUMBER) IS
641: SELECT ppf.sex
642: FROM per_people_f ppf
643: WHERE ppf.person_id = p_person_id ;
644:
645: l_sex per_people_f.sex%TYPE;
646:

Line 645: l_sex per_people_f.sex%TYPE;

641: SELECT ppf.sex
642: FROM per_people_f ppf
643: WHERE ppf.person_id = p_person_id ;
644:
645: l_sex per_people_f.sex%TYPE;
646:
647: l_maternity_benefit_days NUMBER;
648: l_absence_category per_absence_attendance_types.absence_category%TYPE;
649: l_person_id per_absence_attendances.person_id%TYPE;