APPS.HXC_SETUP_VALIDATION_PKG dependencies on HXC_APPROVAL_STYLES

Line 106: hxc_approval_styles has

102: CURSOR csr_get_approval_style_comps ( p_time_recipient_id number,
103: p_approval_style_id number ) IS
104: SELECT 'Y'
105: FROM hxc_approval_comps hac,
106: hxc_approval_styles has
107: WHERE hac.approval_style_id = p_approval_style_id
108: AND hac.time_recipient_id = p_time_recipient_id
109: OR (has.approval_style_id = p_approval_style_id
110: AND has.name = 'Approval on Submit');

Line 153: l_override_approval_style_id hxc_approval_styles.approval_style_id%type;

149: l_rtr_grp_id NUMBER(15);
150: l_app_set_id NUMBER(15);
151: l_approval_period_set_id NUMBER(15);
152: l_approval_style_id NUMBER(15);
153: l_override_approval_style_id hxc_approval_styles.approval_style_id%type;
154: l_elp_terg_id NUMBER(15);
155: l_cla_terg_id NUMBER(15);
156: l_cla_prefs_ok BOOLEAN := FALSE;
157: l_dummy VARCHAR2(1);