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_PERSON_UPLOAD dependencies on HR_H2PI_ELEMENT_ENTRY_VALUES_V

Line 4968: FROM hr_h2pi_element_entry_values_v to_eev,

4964: p_county VARCHAR2) IS
4965: SELECT SUBSTR(fr_eev.screen_entry_value, 8, 4) city_code,
4966: SUM (fr_eev2.screen_entry_value) percentage,
4967: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
4968: FROM hr_h2pi_element_entry_values_v to_eev,
4969: hr_h2pi_element_entry_values_v to_eev2,
4970: hr_h2pi_element_entries_v to_ele,
4971: hr_h2pi_element_entry_values fr_eev,
4972: hr_h2pi_element_entry_values fr_eev2,

Line 4969: hr_h2pi_element_entry_values_v to_eev2,

4965: SELECT SUBSTR(fr_eev.screen_entry_value, 8, 4) city_code,
4966: SUM (fr_eev2.screen_entry_value) percentage,
4967: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
4968: FROM hr_h2pi_element_entry_values_v to_eev,
4969: hr_h2pi_element_entry_values_v to_eev2,
4970: hr_h2pi_element_entries_v to_ele,
4971: hr_h2pi_element_entry_values fr_eev,
4972: hr_h2pi_element_entry_values fr_eev2,
4973: hr_h2pi_element_entries fr_ele

Line 5023: FROM hr_h2pi_element_entry_values_v to_eev,

5019: p_state VARCHAR2) IS
5020: SELECT SUBSTR(fr_eev.screen_entry_value,4,3) county_code,
5021: SUM (fr_eev2.screen_entry_value) percentage,
5022: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5023: FROM hr_h2pi_element_entry_values_v to_eev,
5024: hr_h2pi_element_entry_values_v to_eev2,
5025: hr_h2pi_element_entries_v to_ele,
5026: hr_h2pi_element_entry_values fr_eev,
5027: hr_h2pi_element_entry_values fr_eev2,

Line 5024: hr_h2pi_element_entry_values_v to_eev2,

5020: SELECT SUBSTR(fr_eev.screen_entry_value,4,3) county_code,
5021: SUM (fr_eev2.screen_entry_value) percentage,
5022: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5023: FROM hr_h2pi_element_entry_values_v to_eev,
5024: hr_h2pi_element_entry_values_v to_eev2,
5025: hr_h2pi_element_entries_v to_ele,
5026: hr_h2pi_element_entry_values fr_eev,
5027: hr_h2pi_element_entry_values fr_eev2,
5028: hr_h2pi_element_entries fr_ele

Line 5076: FROM hr_h2pi_element_entry_values_v to_eev,

5072: p_ed_asg_id NUMBER) IS
5073: SELECT SUBSTR(fr_eev.screen_entry_value,1,2) state_code,
5074: SUM (fr_eev2.screen_entry_value) percentage,
5075: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5076: FROM hr_h2pi_element_entry_values_v to_eev,
5077: hr_h2pi_element_entry_values_v to_eev2,
5078: hr_h2pi_element_entries_v to_ele,
5079: hr_h2pi_element_entry_values fr_eev,
5080: hr_h2pi_element_entry_values fr_eev2,

Line 5077: hr_h2pi_element_entry_values_v to_eev2,

5073: SELECT SUBSTR(fr_eev.screen_entry_value,1,2) state_code,
5074: SUM (fr_eev2.screen_entry_value) percentage,
5075: SUM (fr_eev2.screen_entry_value) - SUM (to_eev2.screen_entry_value) pct_diff
5076: FROM hr_h2pi_element_entry_values_v to_eev,
5077: hr_h2pi_element_entry_values_v to_eev2,
5078: hr_h2pi_element_entries_v to_ele,
5079: hr_h2pi_element_entry_values fr_eev,
5080: hr_h2pi_element_entry_values fr_eev2,
5081: hr_h2pi_element_entries fr_ele