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.

APPS.HRI_OPL_SUPH_ORGMGR dependencies on FND_DATE

Line 155: NVL(fnd_date.canonical_to_date(hoi.org_information3), hr_general.start_of_time) start_date,

151: ,SYSDATE
152: FROM hri_cs_suph ,
153: (SELECT hoi.organization_id organization_id,
154: NVL(to_number(hoi.org_information2), -1) manager_person_id ,
155: NVL(fnd_date.canonical_to_date(hoi.org_information3), hr_general.start_of_time) start_date,
156: NVL(fnd_date.canonical_to_date(hoi.org_information4), hr_general.end_of_time) end_date
157: FROM hr_organization_information hoi
158: WHERE hoi.org_information_context = 'Organization Name Alias'
159: AND hoi.org_information2 IS NOT NULL

Line 156: NVL(fnd_date.canonical_to_date(hoi.org_information4), hr_general.end_of_time) end_date

152: FROM hri_cs_suph ,
153: (SELECT hoi.organization_id organization_id,
154: NVL(to_number(hoi.org_information2), -1) manager_person_id ,
155: NVL(fnd_date.canonical_to_date(hoi.org_information3), hr_general.start_of_time) start_date,
156: NVL(fnd_date.canonical_to_date(hoi.org_information4), hr_general.end_of_time) end_date
157: FROM hr_organization_information hoi
158: WHERE hoi.org_information_context = 'Organization Name Alias'
159: AND hoi.org_information2 IS NOT NULL
160: AND EXISTS ( SELECT NULL