APPS.PAY_NL_TAX_PKG dependencies on PER_ALL_PEOPLE_F

Line 35: FROM per_all_people_f per

31: -- Cursor get_db
32: --
33: CURSOR get_dob IS
34: SELECT date_of_birth,per.last_name,paf.assignment_number
35: FROM per_all_people_f per
36: ,per_all_assignments_f paf
37: WHERE per.person_id = paf.person_id
38: AND paf.assignment_id = p_assignment_id
39: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date

Line 103: FROM per_all_people_f per

99: -- Cursor get_db
100: --
101: CURSOR get_dob IS
102: SELECT date_of_birth
103: FROM per_all_people_f per
104: WHERE per.person_id = p_person_id
105: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date;
106:
107: --

Line 146: FROM per_all_people_f per

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

Line 183: FROM per_all_people_f per

179: -- Cursor get_db
180: --
181: CURSOR get_dob IS
182: SELECT date_of_birth
183: FROM per_all_people_f per
184: ,per_all_assignments_f paf
185: WHERE per.person_id = paf.person_id
186: AND paf.assignment_id = p_assignment_id
187: AND l_system_date BETWEEN per.effective_start_date AND per.effective_end_date

Line 542: FROM per_all_people_f pap,

538: -- Cursor to get_dob
539: --
540: CURSOR get_dob IS
541: SELECT date_of_birth
542: FROM per_all_people_f pap,
543: per_all_assignments_f paa
544: where paa.person_id = pap.person_id
545: and paa.assignment_id = p_assignment_id
546: And p_date_earned between pap.effective_start_date and pap.effective_end_date