APPS.HR_ES_UTILITY dependencies on HR_LOOKUPS

Line 377: select 1 from hr_lookups

373: --------------------------------------------------------------------------------
374: FUNCTION validate_cac_lookup (p_province_code VARCHAR2) RETURN NUMBER is
375:
376: CURSOR get_province_code(p_province_code VARCHAR2) is
377: select 1 from hr_lookups
378: where lookup_type='ES_PROVINCE_CODES'
379: and lookup_code=p_province_code;
380:
381: l_check NUMBER;

Line 737: (p_lookup_type IN hr_lookups.lookup_type%TYPE

733: --------------------------------------------------------------------------------
734: -- FUNCTION chk_entry_in_lookup
735: --------------------------------------------------------------------------------
736: FUNCTION chk_entry_in_lookup
737: (p_lookup_type IN hr_lookups.lookup_type%TYPE
738: ,p_entry_val IN hr_lookups.meaning%TYPE
739: ,p_effective_date IN hr_lookups.start_date_active%TYPE
740: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
741: --

Line 738: ,p_entry_val IN hr_lookups.meaning%TYPE

734: -- FUNCTION chk_entry_in_lookup
735: --------------------------------------------------------------------------------
736: FUNCTION chk_entry_in_lookup
737: (p_lookup_type IN hr_lookups.lookup_type%TYPE
738: ,p_entry_val IN hr_lookups.meaning%TYPE
739: ,p_effective_date IN hr_lookups.start_date_active%TYPE
740: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
741: --
742: CURSOR c_entry_in_lookup IS

Line 739: ,p_effective_date IN hr_lookups.start_date_active%TYPE

735: --------------------------------------------------------------------------------
736: FUNCTION chk_entry_in_lookup
737: (p_lookup_type IN hr_lookups.lookup_type%TYPE
738: ,p_entry_val IN hr_lookups.meaning%TYPE
739: ,p_effective_date IN hr_lookups.start_date_active%TYPE
740: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
741: --
742: CURSOR c_entry_in_lookup IS
743: SELECT 'X'

Line 744: FROM hr_lookups hll

740: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
741: --
742: CURSOR c_entry_in_lookup IS
743: SELECT 'X'
744: FROM hr_lookups hll
745: WHERE hll.lookup_type = p_lookup_type
746: AND hll.lookup_code = p_entry_val
747: AND hll.enabled_flag = 'Y'
748: AND p_effective_date BETWEEN NVL(hll.start_date_active, p_effective_date)

Line 944: FROM hr_lookups

940: ,p_lookup_code VARCHAR2) RETURN VARCHAR2 IS
941: --
942: CURSOR csr_lookup IS
943: SELECT description
944: FROM hr_lookups
945: WHERE lookup_type = p_lookup_type
946: AND lookup_code = p_lookup_code;
947: --
948: v_desc VARCHAR2(250);