DBA Data[Home] [Help]

APPS.OZF_PROCESS_SETUP_PVT dependencies on DPP_LOOKUPS

Line 194: FROM dpp_lookups fl

190: --CURSOR csr_process_setup(pc_table process_code_table_type)
191: -- IS
192: SELECT lookup_code
193: BULK COLLECT INTO process_code_tbl
194: FROM dpp_lookups fl
195: WHERE fl.lookup_type='DPP_EXECUTION_PROCESSES'
196: AND nvl(fl.start_date_active,sysdate) <= sysdate
197: AND nvl(fl.end_date_active,sysdate) >= sysdate
198: AND fl.enabled_flag= 'Y'