DBA Data[Home] [Help]

APPS.PER_FR_WORK_CERT dependencies on PER_ALL_ASSIGNMENTS_F

Line 14: per_all_assignments_f asg

10: job.job_definition_id,
11: to_char(asg.effective_start_date, 'DD-MON-YYYY'),
12: to_char(asg.effective_end_date, 'DD-MON-YYYY')
13: FROM per_jobs job,
14: per_all_assignments_f asg
15: WHERE asg.person_id = p_person_id
16: AND asg.job_id = job.job_id
17: AND asg.period_of_service_id = p_period_of_service_id
18: AND asg.primary_flag = 'Y'