APPS.HXT_BATCH_VAL dependencies on PER_BUSINESS_GROUPS

Line 801: p_bg_id IN per_business_groups.business_group_id%TYPE

797: end if;
798: END tcard_approved;
799:
800: FUNCTION legislation_code (
801: p_bg_id IN per_business_groups.business_group_id%TYPE
802: )
803: RETURN VARCHAR2 -- per_business_groups.legislation_code%TYPE
804: IS
805: l_proc VARCHAR2 (72) ;

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

799:
800: FUNCTION legislation_code (
801: p_bg_id IN per_business_groups.business_group_id%TYPE
802: )
803: RETURN VARCHAR2 -- per_business_groups.legislation_code%TYPE
804: IS
805: l_proc VARCHAR2 (72) ;
806:
807: CURSOR csr_legislation_code (

Line 812: FROM per_business_groups pbg

808: p_bg_id IN hr_all_organization_units.business_group_id%TYPE
809: )
810: IS
811: SELECT pbg.legislation_code
812: FROM per_business_groups pbg
813: WHERE pbg.business_group_id = p_bg_id;
814:
815: l_legislation_code per_business_groups.legislation_code%TYPE;
816: BEGIN

Line 815: l_legislation_code per_business_groups.legislation_code%TYPE;

811: SELECT pbg.legislation_code
812: FROM per_business_groups pbg
813: WHERE pbg.business_group_id = p_bg_id;
814:
815: l_legislation_code per_business_groups.legislation_code%TYPE;
816: BEGIN
817: g_debug :=hr_utility.debug_enabled;
818: if g_debug then
819: l_proc := g_package

Line 840: RETURN per_business_groups.legislation_code%TYPE

836: FUNCTION legislation_code (
837: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
838: p_effective_date IN DATE
839: )
840: RETURN per_business_groups.legislation_code%TYPE
841: IS
842: l_proc VARCHAR2 (72) ;
843:
844: CURSOR csr_business_group (

Line 856: l_legislation_code per_business_groups.legislation_code%TYPE;

852: AND p_effective_date BETWEEN paf.effective_start_date
853: AND paf.effective_end_date;
854:
855: l_business_group_id per_assignments_f.business_group_id%TYPE;
856: l_legislation_code per_business_groups.legislation_code%TYPE;
857: BEGIN
858: g_debug :=hr_utility.debug_enabled;
859: if g_debug then
860: l_proc := g_package