APPS.HR_ASSIGNMENT_SET SQL Statements

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

Line: 46

SELECT  'Y' FROM hr_assignment_set_amendments
 WHERE  assignment_set_id = c_assignmentset_id
   AND  assignment_id    = c_assignment_id
   AND  upper(include_or_exclude) = 'I';

Line: 92

select 'Y' from
      per_assignments_f paf,
      hr_assignment_set_amendments hasa
where
       hasa.assignment_set_id = C_ASSIGNMENTSET_ID AND
       hasa.ASSIGNMENT_ID = paf.assignment_id AND
       UPPER(hasa.include_or_exclude) = 'I' AND
       paf.person_id = C_PERSON_ID;