APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_ADD_ASSIGN_INFO_F

Line 4504: FROM hxt_add_assign_info_f asg

4500: IS SELECT /*+ INDEX(asg HXT_ADD_ASSIGN_INFO_ON1)*/
4501: earning_policy,
4502: effective_start_date,
4503: effective_end_date
4504: FROM hxt_add_assign_info_f asg
4505: WHERE assignment_id = p_asg_id
4506: ORDER BY effective_start_date ;
4507:
4508: CURSOR get_earn_group_elements ( p_ep_id IN NUMBER)