APPS.HXC_TIME_CATEGORY_HOOK dependencies on HXC_TIME_CATEGORY_COMPS

Line 61: FROM hxc_time_category_comps tcc

57:
58: CURSOR csr_get_tc_comp ( p_tc_id NUMBER, p_mpc_id NUMBER, p_element_type_id NUMBER ) IS
59: SELECT tcc.time_category_comp_id
60: , tcc.object_version_number
61: FROM hxc_time_category_comps tcc
62: WHERE tcc.time_category_id = p_tc_id
63: AND tcc.component_type_id = p_mpc_id
64: AND tcc.value_id = TO_CHAR(p_element_type_id);
65:

Line 71: FROM hxc_time_category_comps tcc

67: SELECT 'x'
68: FROM hxc_time_categories tc
69: WHERE tc.time_category_id = p_tc_id
70: AND EXISTS ( select 'x'
71: FROM hxc_time_category_comps tcc
72: WHERe tcc.time_category_id = tc.time_category_id );
73:
74: CURSOR csr_get_min_inc_ncr ( p_pap_id NUMBER ) IS
75: SELECT MIN (net_calculation_rule_id)

Line 90: l_tcc_id hxc_time_category_comps.time_category_comp_id%TYPE;

86: l_dec_tc_ovn hxc_time_categories.object_version_number%TYPE;
87: l_inc_tc_id hxc_time_categories.time_category_id%TYPE;
88: l_inc_tc_ovn hxc_time_categories.object_version_number%TYPE;
89:
90: l_tcc_id hxc_time_category_comps.time_category_comp_id%TYPE;
91: l_tcc_ovn hxc_time_category_comps.object_version_number%TYPE;
92: l_mpc_id hxc_mapping_components.mapping_component_id%TYPE;
93:
94: l_tc_info csr_get_time_category_info%ROWTYPE;

Line 91: l_tcc_ovn hxc_time_category_comps.object_version_number%TYPE;

87: l_inc_tc_id hxc_time_categories.time_category_id%TYPE;
88: l_inc_tc_ovn hxc_time_categories.object_version_number%TYPE;
89:
90: l_tcc_id hxc_time_category_comps.time_category_comp_id%TYPE;
91: l_tcc_ovn hxc_time_category_comps.object_version_number%TYPE;
92: l_mpc_id hxc_mapping_components.mapping_component_id%TYPE;
93:
94: l_tc_info csr_get_time_category_info%ROWTYPE;
95: