eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APP_COMP_NOTIFICATIONS_API dependencies on HXC_APPROVAL_STYLES

Line 42: FROM hxc_approval_styles has, hxc_approval_comps hac

38: cursor csr_approval_comp_id
39: (p_approval_style_name in varchar2)
40: is
41: SELECT hac.approval_comp_id, hac.object_version_number
42: FROM hxc_approval_styles has, hxc_approval_comps hac
43: WHERE has.NAME = p_approval_style_name
44: AND has.approval_style_id = hac.approval_style_id
45: AND hac.object_version_number = (SELECT MAX (object_version_number)
46: FROM hxc_approval_comps

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

Line 757: hxc_approval_styles has,

753: CURSOR csr_resend_notifications
754: IS
755: SELECT hacnu.approval_comp_id, hacnu.comp_notification_id
756: FROM hxc_app_comp_notifications hacn,
757: hxc_approval_styles has,
758: hxc_approval_comps hac,
759: hxc_app_comp_notif_usages hacnu
760: WHERE has.NAME = p_approval_style_name
761: AND has.approval_style_id = hac.approval_style_id