APPS.PAY_NL_TAX_PKG dependencies on PER_ALL_PEOPLE_F

Line 143: FROM per_all_people_f per

139: -- Cursor get_db
140: --
141: CURSOR get_dob IS
142: SELECT date_of_birth,per.last_name,paf.assignment_number
143: FROM per_all_people_f per
144: ,per_all_assignments_f paf
145: WHERE per.person_id = paf.person_id
146: AND paf.assignment_id = p_assignment_id
147: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date

Line 218: FROM per_all_people_f per

214: -- Cursor get_db
215: --
216: CURSOR get_dob IS
217: SELECT date_of_birth,per.last_name,paf.assignment_number
218: FROM per_all_people_f per
219: ,per_all_assignments_f paf
220: WHERE per.person_id = paf.person_id
221: AND paf.assignment_id = p_assignment_id
222: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date

Line 298: FROM per_all_people_f per

294: -- Cursor get_db
295: --
296: CURSOR get_dob IS
297: SELECT date_of_birth
298: FROM per_all_people_f per
299: WHERE per.person_id = p_person_id
300: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date;
301:
302: --

Line 355: FROM per_all_people_f per

351: -- Cursor get_db
352: --
353: CURSOR get_dob IS
354: SELECT date_of_birth
355: FROM per_all_people_f per
356: WHERE per.person_id = p_person_id
357: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date;
358:
359: -- Global to get pension age limit

Line 417: FROM per_all_people_f per

413: -- Cursor get_db
414: --
415: CURSOR get_dob IS
416: SELECT date_of_birth
417: FROM per_all_people_f per
418: ,per_all_assignments_f paf
419: WHERE per.person_id = paf.person_id
420: AND paf.assignment_id = p_assignment_id
421: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date

Line 457: FROM per_all_people_f per

453: -- Cursor get_db
454: --
455: CURSOR get_dob IS
456: SELECT date_of_birth
457: FROM per_all_people_f per
458: ,per_all_assignments_f paf
459: WHERE per.person_id = paf.person_id
460: AND paf.assignment_id = p_assignment_id
461: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date

Line 495: FROM per_all_people_f per

491: -- Cursor get_db
492: --
493: CURSOR get_dob IS
494: SELECT date_of_birth
495: FROM per_all_people_f per
496: ,per_all_assignments_f paf
497: WHERE per.person_id = paf.person_id
498: AND paf.assignment_id = p_assignment_id
499: AND l_system_date BETWEEN per.effective_start_date AND per.effective_end_date

Line 854: FROM per_all_people_f pap,

850: -- Cursor to get_dob
851: --
852: CURSOR get_dob IS
853: SELECT date_of_birth
854: FROM per_all_people_f pap,
855: per_all_assignments_f paa
856: where paa.person_id = pap.person_id
857: and paa.assignment_id = p_assignment_id
858: And p_date_earned between pap.effective_start_date and pap.effective_end_date

Line 913: FROM per_all_people_f per

909: -- Cursor get_db
910: --
911: CURSOR get_dob IS
912: SELECT date_of_birth
913: FROM per_all_people_f per
914: ,per_all_assignments_f paf
915: WHERE per.person_id = paf.person_id
916: AND paf.assignment_id = p_assignment_id
917: AND l_date_paid BETWEEN per.effective_start_date AND per.effective_end_date