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 490: csr_v_person_id per_all_people_f.person_id%TYPE

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

Line 491: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE

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

Line 495: FROM per_all_people_f p

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

Line 504: csr_v_person_id per_all_people_f.person_id%TYPE

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