1089:
1090: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
1091: IS
1092: SELECT egr.element_type_id
1093: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei
1094: WHERE egr.egp_id = p_earning_policy_id
1095: AND aei.element_type_id = egr.element_type_id
1096: AND aei.earning_category = 'REG'
1097: AND egr.egr_type <> 'HOL';
1414:
1415: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
1416: IS
1417: SELECT egr.element_type_id
1418: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei
1419: WHERE egr.egp_id = p_earning_policy_id
1420: AND aei.element_type_id = egr.element_type_id
1421: AND aei.earning_category = 'REG'
1422: AND egr.egr_type <> 'HOL';