DBA Data[Home] [Help]

APPS.PER_DIF_STMT_REPORT dependencies on PER_COLLECTIVE_AGREEMENTS

Line 296: per_collective_agreements col_agr

292: per_addresses per_addr,
293: fnd_territories per_ft,
294: per_periods_of_service serv,
295: per_all_assignments_f asg,
296: per_collective_agreements col_agr
297: where per.person_id = p_emp_id
298: and asg.person_id = per.person_id
299: and per.effective_end_date = (select max(effective_end_date)
300: from per_all_people_f