APPS.HXC_TCC_BUS dependencies on HXC_TIME_CATEGORY_COMPS

Line 204: FROM hxc_time_category_comps mpc

200: SELECT 'error'
201: FROM sys.dual
202: WHERE EXISTS (
203: SELECT 'x'
204: FROM hxc_time_category_comps mpc
205: WHERE mpc.time_category_id = p_time_category_id
206: AND mpc.ref_time_category_id = p_ref_time_category_id
207: AND ( mpc.time_category_comp_id <> p_time_category_comp_id OR
208: p_time_category_comp_id IS NULL ) );

Line 215: FROM hxc_time_category_comps tcc

211: , p_ref_time_category_id NUMBER ) IS
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;

Line 221: l_ref_comp_time_cat_id hxc_time_category_comps.ref_time_category_id%TYPE;

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:
221: l_ref_comp_time_cat_id hxc_time_category_comps.ref_time_category_id%TYPE;
222:
223: l_proc varchar2(72);
224:
225: BEGIN

Line 446: FROM hxc_time_category_comps mpc

442: SELECT 'error'
443: FROM sys.dual
444: WHERE EXISTS (
445: SELECT 'x'
446: FROM hxc_time_category_comps mpc
447: WHERE mpc.time_category_id = p_time_category_id
448: AND mpc.component_type_id = p_component_type_id
449: AND mpc.type = p_type
450: AND (