DBA Data[Home] [Help]

APPS.PER_PDS_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 66: from per_all_assignments_f asg,per_periods_of_service pps

62: and pil.lf_evt_ocrd_dt > p_max_fpd;
63: --
64: cursor max_fpd(p_person_id in number) is
65: select max(final_process_date)
66: from per_all_assignments_f asg,per_periods_of_service pps
67: where
68: asg.period_of_service_id = pps.period_of_service_id
69: and asg.effective_end_date <> hr_api.g_eot
70: and asg.person_id = p_person_id;