APPS.HXT_TIME_SUMMARY dependencies on HXT_EARN_GROUPS

Line 4245: FROM hxt_earn_groups egr

4241: AND p_date between egt.effective_start_date
4242: and egt.effective_end_date
4243: AND egt.id = p_egt_id
4244: AND exists (SELECT 'x'
4245: FROM hxt_earn_groups egr
4246: WHERE egr.egt_id = p_egt_id -- SPR C150
4247: AND egr.element_type_id = p_element_type_id
4248: );
4249: RETURN l_retcode;