eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_SG_AEI_LEG_HOOK SQL Statements

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

Line: 57


  SELECT 'X'
  FROM   per_assignment_extra_info
  WHERE  assignment_id    = p_assignment_id
    AND  information_type = p_information_type
    AND  aei_information1 = p_aei_information1
  HAVING count(*) > 3;

Line: 318


  SELECT 'X'
  FROM   per_assignment_extra_info
  WHERE  assignment_id    = p_assignment_id
    AND  information_type = p_information_type
    AND  aei_information1 = p_aei_information1
    AND  ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
    OR  fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
    OR  (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
    OR  fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
  HAVING count(*) > 1;

Line: 335


  SELECT 'X'
  FROM   per_assignment_extra_info
  WHERE  assignment_id    = p_assignment_id
    AND  information_type = p_information_type
    AND  substr(aei_information1,11,3) = substr(p_aei_information1,11,3)
    AND  ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
    OR  fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
    OR  (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
    OR  fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
  HAVING count(*) > 1;