APPS.DPP_EXECUTIONPROCESS_PUB dependencies on DPP_LOOKUPS

Line 62: FROM dpp_lookups dppl,

58: --Cursor to retrieve the process codes from look up
59: CURSOR get_process_codes_csr (p_supp_trd_prf_id NUMBER)
60: IS
61: SELECT dppl.lookup_code
62: FROM dpp_lookups dppl,
63: OZF_PROCESS_SETUP_ALL opsa
64: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
65: AND dppl.tag is not null
66: AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)