APPS.HR_ES_UTILITY dependencies on HR_LOOKUPS

Line 438: select 1 from hr_lookups

434: --------------------------------------------------------------------------------
435: FUNCTION validate_cac_lookup (p_province_code VARCHAR2) RETURN NUMBER is
436:
437: CURSOR get_province_code(p_province_code VARCHAR2) is
438: select 1 from hr_lookups
439: where lookup_type='ES_PROVINCE_CODES'
440: and lookup_code=p_province_code;
441:
442: l_check NUMBER;

Line 817: (p_lookup_type IN hr_lookups.lookup_type%TYPE

813: --------------------------------------------------------------------------------
814: -- FUNCTION chk_entry_in_lookup
815: --------------------------------------------------------------------------------
816: FUNCTION chk_entry_in_lookup
817: (p_lookup_type IN hr_lookups.lookup_type%TYPE
818: ,p_entry_val IN hr_lookups.meaning%TYPE
819: ,p_effective_date IN hr_lookups.start_date_active%TYPE
820: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
821: --

Line 818: ,p_entry_val IN hr_lookups.meaning%TYPE

814: -- FUNCTION chk_entry_in_lookup
815: --------------------------------------------------------------------------------
816: FUNCTION chk_entry_in_lookup
817: (p_lookup_type IN hr_lookups.lookup_type%TYPE
818: ,p_entry_val IN hr_lookups.meaning%TYPE
819: ,p_effective_date IN hr_lookups.start_date_active%TYPE
820: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
821: --
822: CURSOR c_entry_in_lookup IS

Line 819: ,p_effective_date IN hr_lookups.start_date_active%TYPE

815: --------------------------------------------------------------------------------
816: FUNCTION chk_entry_in_lookup
817: (p_lookup_type IN hr_lookups.lookup_type%TYPE
818: ,p_entry_val IN hr_lookups.meaning%TYPE
819: ,p_effective_date IN hr_lookups.start_date_active%TYPE
820: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
821: --
822: CURSOR c_entry_in_lookup IS
823: SELECT 'X'

Line 824: FROM hr_lookups hll

820: ,p_message OUT NOCOPY VARCHAR2) RETURN VARCHAR2 AS
821: --
822: CURSOR c_entry_in_lookup IS
823: SELECT 'X'
824: FROM hr_lookups hll
825: WHERE hll.lookup_type = p_lookup_type
826: AND hll.lookup_code = p_entry_val
827: AND hll.enabled_flag = 'Y'
828: AND p_effective_date BETWEEN NVL(hll.start_date_active, p_effective_date)

Line 1024: FROM hr_lookups

1020: ,p_lookup_code VARCHAR2) RETURN VARCHAR2 IS
1021: --
1022: CURSOR csr_lookup IS
1023: SELECT description
1024: FROM hr_lookups
1025: WHERE lookup_type = p_lookup_type
1026: AND lookup_code = p_lookup_code;
1027: --
1028: v_desc VARCHAR2(250);