APPS.HXC_ELP_UTILS dependencies on HXC_APPLICATION_SET_COMPS_V

Line 91: FROM hxc_application_set_comps_v

87:
88: CURSOR csr_tm_sets
89: IS
90: SELECT DISTINCT application_set_id, time_recipient_id
91: FROM hxc_application_set_comps_v
92: ORDER BY application_set_id;
93:
94: CURSOR csr_app_set_id (p_app_set_id NUMBER)
95: IS

Line 97: FROM hxc_application_set_comps_v

93:
94: CURSOR csr_app_set_id (p_app_set_id NUMBER)
95: IS
96: SELECT DISTINCT (application_set_id) a
97: FROM hxc_application_set_comps_v
98: WHERE time_recipient_id IN
99: (SELECT DISTINCT (time_recipient_id)
100: FROM hxc_application_set_comps_v
101: WHERE application_set_id =

Line 100: FROM hxc_application_set_comps_v

96: SELECT DISTINCT (application_set_id) a
97: FROM hxc_application_set_comps_v
98: WHERE time_recipient_id IN
99: (SELECT DISTINCT (time_recipient_id)
100: FROM hxc_application_set_comps_v
101: WHERE application_set_id =
102: p_app_set_id)
103: AND application_set_id NOT IN
104: (SELECT application_set_id a

Line 105: FROM hxc_application_set_comps_v

101: WHERE application_set_id =
102: p_app_set_id)
103: AND application_set_id NOT IN
104: (SELECT application_set_id a
105: FROM hxc_application_set_comps_v
106: WHERE time_recipient_id NOT IN
107: (SELECT DISTINCT (time_recipient_id)
108: FROM hxc_application_set_comps_v
109: WHERE application_set_id =

Line 108: FROM hxc_application_set_comps_v

104: (SELECT application_set_id a
105: FROM hxc_application_set_comps_v
106: WHERE time_recipient_id NOT IN
107: (SELECT DISTINCT (time_recipient_id)
108: FROM hxc_application_set_comps_v
109: WHERE application_set_id =
110: p_app_set_id));
111:
112: CURSOR cache_app_set

Line 115: FROM hxc_application_set_comps_v

111:
112: CURSOR cache_app_set
113: IS
114: SELECT application_set_id a, COUNT (*) cnt
115: FROM hxc_application_set_comps_v
116: GROUP BY application_set_id;
117:
118: CURSOR tm_rec_transfer(p_tbb_id NUMBER, p_tbb_ovn NUMBER, p_time_rec_id NUMBER)
119: IS

Line 1880: FROM hxc_application_set_comps_v

1876:
1877: CURSOR csr_app_set_id (p_tim_rec_id NUMBER)
1878: IS
1879: SELECT DISTINCT (application_set_id) A
1880: FROM hxc_application_set_comps_v
1881: WHERE time_recipient_id = p_tim_rec_id;
1882:
1883:
1884: l_proc VARCHAR2 (30);