APPS.PAY_NL_TAX_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 144: ,per_all_assignments_f paf

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

Line 219: ,per_all_assignments_f paf

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

Line 418: ,per_all_assignments_f paf

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

Line 458: ,per_all_assignments_f paf

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

Line 496: ,per_all_assignments_f paf

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

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

523: -- Cursor get_lbr_tx_red_ind
524: --
525: CURSOR get_lbr_tx_red_ind(p_person_id number,p_assignment_id number) IS
526: SELECT scl.segment7
527: FROM hr_soft_coding_keyflex scl,per_all_assignments_f paa,fnd_sessions ses
528: WHERE
529: paa.person_id=p_person_id and
530: paa.assignment_id <> nvl(p_assignment_id,-1) and
531: scl.soft_coding_keyflex_id=paa.soft_coding_keyflex_id and

Line 842: per_all_assignments_f paa

838:
839: CURSOR get_hire_date IS
840: SELECT date_start from
841: per_periods_of_service pps,
842: per_all_assignments_f paa
843: where pps.person_id = paa.person_id
844: and paa.assignment_id = p_assignment_id
845: and pps.business_group_id = p_business_group_id
846: and paa.business_group_id = p_business_group_id

Line 855: per_all_assignments_f paa

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

Line 914: ,per_all_assignments_f paf

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