APPS.PER_FR_WORK_CERT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

SELECT job.job_id,
       job.job_definition_id,
       to_char(asg.effective_start_date, 'DD-MON-YYYY'),
       to_char(asg.effective_end_date, 'DD-MON-YYYY')
FROM   per_jobs job,
       per_all_assignments_f asg
WHERE  asg.person_id = p_person_id
AND    asg.job_id = job.job_id
AND    asg.period_of_service_id = p_period_of_service_id
AND    asg.primary_flag = 'Y'
ORDER BY asg.effective_start_date;