DBA Data[Home] [Help]

APPS.DPP_EXECUTIONPROCESS_PVT dependencies on DPP_LOOKUPS

Line 1115: FROM dpp_lookups dppl,

1111: --Cursor to retrieve the process codes from look up
1112: CURSOR get_process_codes_csr (p_supp_trd_prf_id NUMBER)
1113: IS
1114: SELECT dppl.lookup_code
1115: FROM dpp_lookups dppl,
1116: OZF_PROCESS_SETUP_ALL opsa
1117: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
1118: AND dppl.tag is not null
1119: AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)