APPS.HXT_BATCH_VAL dependencies on PER_BUSINESS_GROUPS

Line 892: p_bg_id IN per_business_groups.business_group_id%TYPE

888: end if;
889: END tcard_approved;
890:
891: FUNCTION legislation_code (
892: p_bg_id IN per_business_groups.business_group_id%TYPE
893: )
894: RETURN VARCHAR2 -- per_business_groups.legislation_code%TYPE
895: IS
896: l_proc VARCHAR2 (72) ;

Line 894: RETURN VARCHAR2 -- per_business_groups.legislation_code%TYPE

890:
891: FUNCTION legislation_code (
892: p_bg_id IN per_business_groups.business_group_id%TYPE
893: )
894: RETURN VARCHAR2 -- per_business_groups.legislation_code%TYPE
895: IS
896: l_proc VARCHAR2 (72) ;
897:
898: CURSOR csr_legislation_code (

Line 903: FROM per_business_groups pbg

899: p_bg_id IN hr_all_organization_units.business_group_id%TYPE
900: )
901: IS
902: SELECT pbg.legislation_code
903: FROM per_business_groups pbg
904: WHERE pbg.business_group_id = p_bg_id;
905:
906: l_legislation_code per_business_groups.legislation_code%TYPE;
907: BEGIN

Line 906: l_legislation_code per_business_groups.legislation_code%TYPE;

902: SELECT pbg.legislation_code
903: FROM per_business_groups pbg
904: WHERE pbg.business_group_id = p_bg_id;
905:
906: l_legislation_code per_business_groups.legislation_code%TYPE;
907: BEGIN
908: g_debug :=hr_utility.debug_enabled;
909: if g_debug then
910: l_proc := g_package

Line 931: RETURN per_business_groups.legislation_code%TYPE

927: FUNCTION legislation_code (
928: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
929: p_effective_date IN DATE
930: )
931: RETURN per_business_groups.legislation_code%TYPE
932: IS
933: l_proc VARCHAR2 (72) ;
934:
935: CURSOR csr_business_group (

Line 947: l_legislation_code per_business_groups.legislation_code%TYPE;

943: AND p_effective_date BETWEEN paf.effective_start_date
944: AND paf.effective_end_date;
945:
946: l_business_group_id per_assignments_f.business_group_id%TYPE;
947: l_legislation_code per_business_groups.legislation_code%TYPE;
948: BEGIN
949: g_debug :=hr_utility.debug_enabled;
950: if g_debug then
951: l_proc := g_package