APPS.PAY_NL_TAX_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 36: ,per_all_assignments_f paf

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
40: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 147: ,per_all_assignments_f paf

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
151: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 184: ,per_all_assignments_f paf

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
188: AND l_system_date BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 215: FROM hr_soft_coding_keyflex scl,per_all_assignments_f paa,fnd_sessions ses

211: -- Cursor get_lbr_tx_red_ind
212: --
213: CURSOR get_lbr_tx_red_ind(p_person_id number,p_assignment_id number) IS
214: SELECT scl.segment7
215: FROM hr_soft_coding_keyflex scl,per_all_assignments_f paa,fnd_sessions ses
216: WHERE
217: paa.person_id=p_person_id and
218: paa.assignment_id <> nvl(p_assignment_id,-1) and
219: scl.soft_coding_keyflex_id=paa.soft_coding_keyflex_id and

Line 530: per_all_assignments_f paa

526:
527: CURSOR get_hire_date IS
528: SELECT date_start from
529: per_periods_of_service pps,
530: per_all_assignments_f paa
531: where pps.person_id = paa.person_id
532: and paa.assignment_id = p_assignment_id
533: and pps.business_group_id = p_business_group_id
534: and paa.business_group_id = p_business_group_id

Line 543: per_all_assignments_f paa

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
547: and p_date_earned between paa.effective_start_date and paa.effective_end_date