APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_ADD_ASSIGN_INFO_F

Line 3716: FROM hxt_add_assign_info_f asg

3712: IS SELECT /*+ INDEX(asg HXT_ADD_ASSIGN_INFO_ON1)*/
3713: earning_policy,
3714: effective_start_date,
3715: effective_end_date
3716: FROM hxt_add_assign_info_f asg
3717: WHERE assignment_id = p_asg_id
3718: ORDER BY effective_start_date ;
3719:
3720: CURSOR get_earn_group_elements ( p_ep_id IN NUMBER)