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.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_ADD_ELEM_INFO_F

Line 587: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei

583:
584: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
585: IS
586: SELECT egr.element_type_id
587: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei
588: WHERE egr.egp_id = p_earning_policy_id
589: AND aei.element_type_id = egr.element_type_id
590: AND aei.earning_category = 'REG'
591: AND egr.egr_type <> 'HOL';

Line 901: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei

897:
898: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
899: IS
900: SELECT egr.element_type_id
901: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei
902: WHERE egr.egp_id = p_earning_policy_id
903: AND aei.element_type_id = egr.element_type_id
904: AND aei.earning_category = 'REG'
905: AND egr.egr_type <> 'HOL';