DBA Data[Home] [Help]

APPS.HR_NL_LAW_SAMEN_REPORT dependencies on PER_ASSIGNMENTS_F

Line 475: , per_assignments_f paf

471: ,paf.job_id job
472: ,paf.person_id
473:
474: from per_periods_of_service pos
475: , per_assignments_f paf
476:
477: where to_number(to_char(nvl(pos.date_start,sysdate),'YYYY')) <= P_REPORT_YEAR
478: and to_number(to_char(nvl(pos.actual_termination_date,sysdate+50000),'YYYY')) = P_REPORT_YEAR
479: and pos.period_of_service_id = paf.period_of_service_id