DBA Data[Home] [Help]

APPS.BEN_EFC_FUNCTIONS dependencies on HR_LOOKUPS

Line 561: FROM hr_lookups lok

557: --
558: CURSOR csr_find_lowest_phase
559: IS
560: SELECT to_number(substr(lok.lookup_code,2)) action_num
561: FROM hr_lookups lok
562: WHERE lok.lookup_type = 'EFC_PROGRESS_STATUS'
563: AND substr(lok.lookup_code,1,1) = 'C'
564: ORDER BY lok.lookup_code;
565: --