APPS.HXC_ASC_UPLOAD_PKG dependencies on HXC_APPLICATION_SETS_V

Line 10: FROM hxc_application_sets_v

6: FUNCTION get_application_set_id ( p_application_set_name IN VARCHAR2 ) RETURN NUMBER IS
7:
8: CURSOR csr_get_application_set_id IS
9: SELECT application_set_id
10: FROM hxc_application_sets_v
11: WHERE application_set_name = p_application_set_name;
12:
13: l_application_set_id hxc_entity_groups.entity_group_id%TYPE;
14:

Line 81: FROM hxc_application_sets_v aps

77: , DECODE( NVL( sc.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
78: INTO l_application_set_comp_id
79: , l_ovn
80: , l_owner
81: FROM hxc_application_sets_v aps
82: , hxc_application_set_comps_v sc
83: WHERE sc.time_recipient_id = l_time_recipient_id
84: AND aps.application_set_id = sc.application_set_id
85: AND aps.application_set_id = l_application_set_id;