APPS.HR_ORU_BUS dependencies on HR_LOOKUPS

Line 878: FROM hr_lookups

874: l_exists VARCHAR2(1) := 'N';
875: --
876: cursor csr_type IS
877: SELECT 'Y'
878: FROM hr_lookups
879: WHERE lookup_type = 'ORG_TYPE'
880: AND lookup_code = p_type
881: AND enabled_flag = 'Y'
882: AND p_effective_date BETWEEN nvl(start_date_active,p_effective_date)

Line 954: FROM hr_lookups

950: l_exists VARCHAR2(1) := 'N';
951: --
952: cursor csr_internal_external_flag IS
953: SELECT 'Y'
954: FROM hr_lookups
955: WHERE lookup_type = 'INTL_EXTL'
956: AND lookup_code = p_internal_external_flag
957: AND enabled_flag = 'Y'
958: AND p_effective_date BETWEEN nvl(start_date_active,p_effective_date)