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.PQH_PQHEEO5_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS_V

Line 57: HR_ORGANIZATION_UNITS_V HOU,

53: ( SELECT
54: ASS.LOCATION_ID
55: FROM
56: PER_ALL_ASSIGNMENTS_F ASS,
57: HR_ORGANIZATION_UNITS_V HOU,
58: PER_ALL_PEOPLE_F PEO
59: WHERE ASS.ORGANIZATION_ID = HOU.ORGANIZATION_ID
60: AND ASS.PERSON_ID = PEO.PERSON_ID
61: AND CP_REPORT_DATE between ASS.EFFECTIVE_START_DATE

Line 79: HR_ORGANIZATION_UNITS_V HOU

75: COUNT(1)
76: INTO
77: L_NO_OF_SCHOOLS
78: FROM
79: HR_ORGANIZATION_UNITS_V HOU
80: WHERE HOU.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;
81: CP_NO_OF_SCHOOLS := L_NO_OF_SCHOOLS;
82: RETURN (L_NO_OF_ANNEXES);
83: END CF_NO_OF_ANNEXESFORMULA;