APPS.PAY_SE_WORK_TIME_CERTIFICATE dependencies on PER_ALL_PEOPLE_F

Line 214: l_last_name per_all_people_f.last_name%TYPE;

210: -- Variable Required
211: l_set NUMBER;
212: l_report_effective_date DATE;
213: l_person_number VARCHAR2 (100);
214: l_last_name per_all_people_f.last_name%TYPE;
215: l_first_name per_all_people_f.first_name%TYPE;
216: l_hired_from DATE;
217: l_hired_to DATE;
218: l_still_employed VARCHAR2 (10);

Line 215: l_first_name per_all_people_f.first_name%TYPE;

211: l_set NUMBER;
212: l_report_effective_date DATE;
213: l_person_number VARCHAR2 (100);
214: l_last_name per_all_people_f.last_name%TYPE;
215: l_first_name per_all_people_f.first_name%TYPE;
216: l_hired_from DATE;
217: l_hired_to DATE;
218: l_still_employed VARCHAR2 (10);
219: l_absence_from VARCHAR2 (100);

Line 488: csr_v_person_id per_all_people_f.person_id%TYPE

484:
485: lr_get_assign_min_start_date csr_get_assign_min_start_date%ROWTYPE;
486:
487: CURSOR csr_person_info (
488: csr_v_person_id per_all_people_f.person_id%TYPE
489: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE
490: )
491: IS
492: SELECT *

Line 489: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE

485: lr_get_assign_min_start_date csr_get_assign_min_start_date%ROWTYPE;
486:
487: CURSOR csr_person_info (
488: csr_v_person_id per_all_people_f.person_id%TYPE
489: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE
490: )
491: IS
492: SELECT *
493: FROM per_all_people_f p

Line 493: FROM per_all_people_f p

489: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE
490: )
491: IS
492: SELECT *
493: FROM per_all_people_f p
494: WHERE p.business_group_id = g_business_group_id
495: AND p.person_id = csr_v_person_id
496: AND csr_v_effective_date BETWEEN p.effective_start_date
497: AND p.effective_end_date;

Line 502: csr_v_person_id per_all_people_f.person_id%TYPE

498:
499: lr_person_info csr_person_info%ROWTYPE;
500:
501: CURSOR csr_assignment_info (
502: csr_v_person_id per_all_people_f.person_id%TYPE
503: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE
504: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
505: )
506: IS