APPS.HR_ORU_BUS dependencies on HR_LOOKUPS

Line 877: FROM hr_lookups

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

Line 953: FROM hr_lookups

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