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

Line 1024: SELECT NVL(MAX(patch_name),'GEOCODE_1900_Q1') FROM hr_h2pi_patch_status

1020: --
1021: PROCEDURE validate_geocode(p_from_client_id VARCHAR2) IS
1022:
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:

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 1031: l_ud_geocode hr_h2pi_patch_status.patch_name%TYPE;

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;
1032: l_ed_geocode hr_h2pi_patch_status.patch_name%TYPE;
1033:
1034: l_jurisdiction_code hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1035: l_jurisdiction_code_comp hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;

Line 1032: l_ed_geocode hr_h2pi_patch_status.patch_name%TYPE;

1028:
1029: l_geocode_status VARCHAR2(30);
1030:
1031: l_ud_geocode hr_h2pi_patch_status.patch_name%TYPE;
1032: l_ed_geocode hr_h2pi_patch_status.patch_name%TYPE;
1033:
1034: l_jurisdiction_code hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1035: l_jurisdiction_code_comp hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1036:

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);

Line 1127: FROM hr_h2pi_patch_status

1123:
1124: FETCH csr_ed_geocode INTO l_ed_geocode;
1125: SELECT count(*)
1126: INTO l_ud_more_then_two_ver_ahead
1127: FROM hr_h2pi_patch_status
1128: WHERE patch_name > l_ed_geocode
1129: AND client_id = p_from_client_id;
1130:
1131: IF l_ud_more_then_two_ver_ahead > 1 then