DBA Data[Home] [Help]

APPS.HXC_APP_COMP_NOTIFICATIONS_API dependencies on HXC_TIME_RECIPIENTS

Line 70: FROM hxc_approval_styles has, hxc_approval_comps hac, hxc_time_recipients htr

66: cursor csr_comp_from_recipient
67: ( p_approval_style_name in varchar2
68: ,p_time_recipient_name in varchar2) is
69: SELECT hac.approval_comp_id, hac.object_version_number
70: FROM hxc_approval_styles has, hxc_approval_comps hac, hxc_time_recipients htr
71: WHERE has.NAME = p_approval_style_name
72: AND htr.NAME = p_time_recipient_name
73: AND has.approval_style_id = hac.approval_style_id
74: AND htr.time_recipient_id = hac.time_recipient_id