APPS.HR_NL_ASG_EXTRA_INFO_CHECKS SQL Statements

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

Line: 29

  SELECT paaf1.assignment_id
  FROM per_all_assignments_f paaf1
      , per_assignment_extra_info paei
      , per_all_assignments_f paaf
  WHERE paei.assignment_extra_info_id=P_ASSIGNMENT_EXTRA_INFO_ID
    AND paei.information_type='NL_NUMIV_OVERRIDE'
    AND paaf.assignment_id=paei.assignment_id
    AND paaf.person_id=paaf1.person_id
    AND paaf1.assignment_id <>paaf.assignment_id
    AND paaf1.assignment_type = 'E'; --11723380

Line: 41

  SELECT aei_information1 NUMIV_OVERRIDE
       , paaf.assignment_sequence ASSIGNMENT_SEQUENCE
  FROM per_assignment_extra_info paei
     , per_all_assignments_f paaf
  WHERE paaf.assignment_id = c_asg_id
   AND  paei.aei_information_category(+) = 'NL_NUMIV_OVERRIDE'
   AND paei.assignment_id(+)= paaf.assignment_id;

Line: 88

  SELECT paaf1.assignment_id
  FROM per_all_assignments_f paaf1
     , per_all_assignments_f paaf
  WHERE paaf.assignment_id=P_ASSIGNMENT_ID
    AND paaf.person_id=paaf1.person_id
    AND paaf1.assignment_id <>paaf.assignment_id
    AND paaf1.assignment_type = 'E'; --11723380

Line: 97

  SELECT aei_information1 NUMIV_OVERRIDE
       , paaf.assignment_sequence ASSIGNMENT_SEQUENCE
  FROM per_assignment_extra_info paei, per_all_assignments_f paaf
  WHERE paaf.assignment_id = c_asg_id
   AND  paei.aei_information_category(+) = 'NL_NUMIV_OVERRIDE'
   AND  paei.assignment_id(+)= paaf.assignment_id;