APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on HXC_TIME_CATEGORY_COMPS

Line 481: l_time_category_comp_id hxc_time_category_comps.TIME_CATEGORY_COMP_ID%type;

477: p_value_id IN VARCHAR2,
478: p_component_type_id IN NUMBER,
479: p_time_category_comp_exists OUT nocopy VARCHAR2) IS
480:
481: l_time_category_comp_id hxc_time_category_comps.TIME_CATEGORY_COMP_ID%type;
482: l_time_category_comp_ovn hxc_time_category_comps.OBJECT_VERSION_NUMBER%type;
483: l_component_type_id hxc_mapping_components.MAPPING_COMPONENT_ID%TYPE;
484:
485: l_proc VARCHAR2(100);

Line 482: l_time_category_comp_ovn hxc_time_category_comps.OBJECT_VERSION_NUMBER%type;

478: p_component_type_id IN NUMBER,
479: p_time_category_comp_exists OUT nocopy VARCHAR2) IS
480:
481: l_time_category_comp_id hxc_time_category_comps.TIME_CATEGORY_COMP_ID%type;
482: l_time_category_comp_ovn hxc_time_category_comps.OBJECT_VERSION_NUMBER%type;
483: l_component_type_id hxc_mapping_components.MAPPING_COMPONENT_ID%TYPE;
484:
485: l_proc VARCHAR2(100);
486:

Line 516: FROM hxc_time_category_comps

512: END IF;
513:
514: SELECT 'Y'
515: INTO p_time_category_comp_exists
516: FROM hxc_time_category_comps
517: WHERE time_category_id = p_time_category_id
518: AND value_id = p_value_id;
519:
520: IF g_debug THEN

Line 531: FROM hxc_time_category_comps

527: SELECT time_category_comp_id,
528: object_version_number
529: INTO l_time_category_comp_id,
530: l_time_category_comp_ovn
531: FROM hxc_time_category_comps
532: WHERE time_category_id = p_time_category_id
533: AND value_id = p_value_id;
534:
535: IF g_debug THEN