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