DBA Data[Home] [Help]

APPS.DPP_MIG_ADJ_PARA_APPROVAL_PVT dependencies on DPP_LOOKUPS

Line 511: FROM dpp_lookups dppl,

507: --Cursor to fetch the processes either at supplier trade profile or system parameters
508: CURSOR get_process_codes_csr (p_supp_trd_prf_id NUMBER, p_org_id NUMBER)
509: IS
510: SELECT dppl.lookup_code
511: FROM dpp_lookups dppl,
512: ozf_process_setup_all opsa
513: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
514: AND dppl.tag is not null
515: AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)