APPS.PER_CANCEL_APPLICATION_API SQL Statements

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

Line: 22

    select pa.date_received
    from   per_applications pa
    where  pa.person_id = p_person_id
    and    pa.application_id = p_application_id;

Line: 28

    select pt.system_person_type,
	   p.effective_start_date
    from   per_all_people_f p,
           per_person_types pt
    where  p.person_id      = p_person_id
    and    p.person_type_id = pt.person_type_id
    and    p_received_date between
           p.effective_start_date and p.effective_end_date ;