APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on HXC_TK_GROUP_QUERY_CRITERIA

Line 30: l_object_version_number hxc_tk_group_query_criteria.object_version_number%TYPE;

26: --
27: -- Declare cursors and local variables
28: --
29: l_proc varchar2(72) ;
30: l_object_version_number hxc_tk_group_query_criteria.object_version_number%TYPE;
31: l_tk_group_query_criteria_id hxc_tk_group_query_criteria.tk_group_query_criteria_id%TYPE;
32: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;
33: --
34: begin

Line 31: l_tk_group_query_criteria_id hxc_tk_group_query_criteria.tk_group_query_criteria_id%TYPE;

27: -- Declare cursors and local variables
28: --
29: l_proc varchar2(72) ;
30: l_object_version_number hxc_tk_group_query_criteria.object_version_number%TYPE;
31: l_tk_group_query_criteria_id hxc_tk_group_query_criteria.tk_group_query_criteria_id%TYPE;
32: l_tk_group_query_id hxc_tk_group_queries.tk_group_query_id%TYPE;
33: --
34: begin
35: g_debug :=hr_utility.debug_enabled;

Line 212: l_object_version_number hxc_tk_group_query_criteria.object_version_number%TYPE := p_object_version_number;

208: --
209: -- Declare cursors and local variables
210: --
211: l_proc varchar2(72) ;
212: l_object_version_number hxc_tk_group_query_criteria.object_version_number%TYPE := p_object_version_number;
213: --
214: begin
215: --
216: g_debug :=hr_utility.debug_enabled;

Line 808: FROM hxc_tk_group_query_criteria tkgqc

804: SELECT 'x'
805: FROM sys.dual
806: WHERE EXISTS (
807: SELECT 'x'
808: FROM hxc_tk_group_query_criteria tkgqc
809: WHERE tkgqc.tk_group_query_id = p_tk_group_query_id
810: AND tkgqc.criteria_id = p_criteria_id
811: AND tkgqc.criteria_type = p_criteria_type
812: AND