APPS.HXT_TIME_SUMMARY dependencies on HXT_EARN_GROUPS

Line 2913: FROM hxt_earn_groups egr

2909: AND p_date between egt.effective_start_date
2910: and egt.effective_end_date
2911: AND egt.id = p_egt_id
2912: AND exists (SELECT 'x'
2913: FROM hxt_earn_groups egr
2914: WHERE egr.egt_id = p_egt_id -- SPR C150
2915: AND egr.element_type_id = p_element_type_id
2916: );
2917: RETURN l_retcode;