APPS.HXC_HAC_UPLOAD_PKG dependencies on HXC_APPROVAL_COMPS

Line 18: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;

14: , p_owner VARCHAR2
15: , p_custom_mode VARCHAR2 ) IS
16:
17:
18: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
19: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
20: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
21: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
22: l_ovn hxc_approval_styles.object_version_number%TYPE := NULL;

Line 21: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;

17:
18: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
19: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
20: l_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE;
21: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
22: l_ovn hxc_approval_styles.object_version_number%TYPE := NULL;
23: l_owner VARCHAR2(6);
24:
25: FUNCTION get_approval_style_id ( p_name VARCHAR2 ) RETURN NUMBER IS

Line 81: FROM hxc_approval_comps hac

77: , DECODE( NVL(hac.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
78: INTO l_approval_comp_id
79: , l_ovn
80: , l_owner
81: FROM hxc_approval_comps hac
82: , hxc_approval_styles has
83: WHERE has.name = P_AS_NAME
84: AND hac.approval_style_id = has.approval_style_id
85: AND hac.time_recipient_id = l_time_recipient_id