[Home] [Help]
101: INTO l_approval_period_comp_id
102: , l_ovn
103: , l_owner
104: FROM hxc_approval_period_sets aps
105: , hxc_approval_period_comps_v sc
106: WHERE sc.time_recipient_id = l_time_recipient_id
107: AND sc.recurring_period_id = l_recurring_period_id
108: AND sc.approval_period_set_id = aps.approval_period_set_id
109: AND aps.approval_period_set_id = l_approval_period_set_id;