DBA Data[Home] [Help]

APPS.HXT_TIMECARD_INFO dependencies on HXT_ADD_ELEM_INFO_F

Line 438: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei

434:
435: CURSOR c_get_base_hours_type (p_earning_policy_id NUMBER)
436: IS
437: SELECT egr.element_type_id
438: FROM hxt_earning_rules egr, hxt_add_elem_info_f aei
439: WHERE egr.egp_id = p_earning_policy_id
440: AND aei.element_type_id = egr.element_type_id
441: AND aei.earning_category = 'REG';
442: l_update_flag varchar2(1) := 'N';