APPS.PER_QH_SUMMARY_QUERY SQL Statements

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

Line: 18

select pea.attended_start_date
,      pe.name
,      pea.full_time
,      pea.attended_end_date
from   per_establishments pe
,      per_establishment_attendances pea
where  pea.person_id=p_person_id
and    pea.establishment_id=pe.establishment_id(+)
order by attended_end_date desc, attended_start_date desc;

Line: 90

l_out_rec.resume_last_updated           :=l_main_rec.resume_last_updated;

Line: 175

l_out_rec.person_update_allowed         :=l_main_rec.person_update_allowed;

Line: 330

l_out_rec.asg_update_allowed            :=l_main_rec.asg_update_allowed;