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.HR_H2PI_VALIDATE dependencies on HR_H2PI_PATCH_STATUS_V

Line 1027: SELECT NVL(MAX(patch_name),'GEOCODE_1900_Q1') FROM hr_h2pi_patch_status_v;

1023: CURSOR csr_ud_geocode IS
1024: SELECT NVL(MAX(patch_name),'GEOCODE_1900_Q1') FROM hr_h2pi_patch_status
1025: WHERE client_id = p_from_client_id;
1026: CURSOR csr_ed_geocode IS
1027: SELECT NVL(MAX(patch_name),'GEOCODE_1900_Q1') FROM hr_h2pi_patch_status_v;
1028:
1029: l_geocode_status VARCHAR2(30);
1030:
1031: l_ud_geocode hr_h2pi_patch_status.patch_name%TYPE;

Line 1116: FROM hr_h2pi_patch_status_v

1112: OPEN csr_ed_geocode;
1113: FETCH csr_ud_geocode INTO l_ud_geocode;
1114: SELECT count(*)
1115: INTO l_ed_more_then_two_ver_ahead
1116: FROM hr_h2pi_patch_status_v
1117: WHERE patch_name > l_ud_geocode;
1118:
1119: IF l_ed_more_then_two_ver_ahead > 1 then
1120: hr_utility.set_location(l_proc, 20);