APPS.HXT_INTERFACE_UTILITIES dependencies on HR_SOFT_CODING_KEYFLEX

Line 934: RETURN hr_soft_coding_keyflex.segment1%TYPE

930: FUNCTION gre (
931: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
932: p_effective_date IN per_all_assignments_f.effective_start_date%TYPE
933: )
934: RETURN hr_soft_coding_keyflex.segment1%TYPE
935: IS
936: l_proc proc_name ;
937:
938: CURSOR csr_gre (

Line 944: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck

940: p_effective_date per_all_assignments_f.effective_start_date%TYPE
941: )
942: IS
943: SELECT hsck.segment1 gre
944: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck
945: WHERE paaf.assignment_id = p_assignment_id
946: AND p_effective_date BETWEEN paaf.effective_start_date
947: AND paaf.effective_end_date
948: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;

Line 950: l_gre hr_soft_coding_keyflex.segment1%TYPE;

946: AND p_effective_date BETWEEN paaf.effective_start_date
947: AND paaf.effective_end_date
948: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;
949:
950: l_gre hr_soft_coding_keyflex.segment1%TYPE;
951: BEGIN
952: g_debug :=hr_utility.debug_enabled;
953: if g_debug then
954: l_proc := g_package