651:
652: CURSOR csr_get_all_fields
653: IS
654: SELECT h.lookup_code
655: FROM hr_lookups h
656: WHERE h.lookup_type = 'HR_SE_ALECTA_FIELDS'
657: AND h.enabled_flag = 'Y'
658: ORDER BY h.meaning;
659:
659:
660: CURSOR csr_get_all_events (csr_v_fields VARCHAR2)
661: IS
662: SELECT h.lookup_code
663: FROM hr_lookups h
664: WHERE h.lookup_type = 'HR_SE_EVENT'
665: AND h.enabled_flag = 'Y'
666: AND ( ( SUBSTR (csr_v_fields, 1, 2) = 'ET'
667: AND (lookup_code <> 'FK')