APPS.HXC_TCC_BUS dependencies on HXC_TIME_CATEGORIES

Line 196: FROM hxc_time_categories htc

192: SELECT 'ok'
193: FROM sys.dual
194: WHERE EXISTS (
195: SELECT 'x'
196: FROM hxc_time_categories htc
197: WHERE htc.time_category_id = p_ref_time_category_id );
198:
199: CURSOR csr_chk_code IS
200: SELECT 'error'

Line 216: , hxc_time_categories htc

212:
213: CURSOR csr_get_child_comps IS
214: SELECT tcc.ref_time_category_id
215: FROM hxc_time_category_comps tcc
216: , hxc_time_categories htc
217: WHERE htc.time_category_id = p_ref_time_category_id
218: AND htc.time_category_id = tcc.time_category_id
219: AND tcc.ref_time_category_id IS NOT NULL;
220: