DBA Data[Home] [Help]

APPS.PAY_SE_ALECTA dependencies on HR_LOOKUPS

Line 695: FROM hr_lookups h

691:
692: CURSOR csr_get_all_fields
693: IS
694: SELECT h.lookup_code
695: FROM hr_lookups h
696: WHERE h.lookup_type = 'HR_SE_ALECTA_FIELDS'
697: AND h.enabled_flag = 'Y'
698: ORDER BY h.meaning;
699:

Line 703: FROM hr_lookups h

699:
700: CURSOR csr_get_all_events (csr_v_fields VARCHAR2)
701: IS
702: SELECT h.lookup_code
703: FROM hr_lookups h
704: WHERE h.lookup_type = 'HR_SE_EVENT'
705: AND h.enabled_flag = 'Y'
706: AND ( ( SUBSTR (csr_v_fields, 1, 2) = 'ET'
707: AND (lookup_code <> 'FK')