APPS.PAY_NL_EOY_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 114: FROM per_periods_of_service pp,per_all_assignments_f assg

110:
111: --15971960
112: CURSOR get_per_fpd(c_assignment_id NUMBER,c_asg_end_dt DATE) IS
113: SELECT pp.final_process_date
114: FROM per_periods_of_service pp,per_all_assignments_f assg
115: WHERE pp.person_id = assg.person_id
116: AND assg.assignment_id = c_assignment_id
117: AND pp.final_process_date > c_asg_end_dt
118: ORDER BY final_process_date DESC;

Line 1063: AND EXISTS (SELECT 1 from per_periods_of_service ppos

1059: where paaf.assignment_id = asg.assignment_id
1060: and fnd_date.canonical_to_date(p_date) -1 BETWEEN paaf.effective_start_date and paaf.effective_end_date
1061: )*/
1062:
1063: AND EXISTS (SELECT 1 from per_periods_of_service ppos
1064: where ppos.person_id = asg.person_id
1065: AND ppos.DATE_START < fnd_date.canonical_to_date (p_date)
1066: AND (ppos.ACTUAL_TERMINATION_DATE IS NULL --Not Terminated
1067: OR nvl(ppos.FINAL_PROCESS_DATE,ppos.ACTUAL_TERMINATION_DATE)