APPS.WSH_WF_STD dependencies on WSH_LOOKUPS

Line 1439: -- Description: This Procedure queries from the WSH_LOOKUPS for any custom

1435: -- x_wf_process - Returns the custom process name specified
1436: -- with the lookups else the orginial process
1437: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1438: --
1439: -- Description: This Procedure queries from the WSH_LOOKUPS for any custom
1440: -- process name specified by the User through the lookups for
1441: -- a particular process else returns the original process
1442: ---------------------------------------------------------------------------------------
1443:

Line 1453: from WSH_LOOKUPS where lookup_type = p_wf_process and lookup_code = p_org_code

1449: l_custom_process VARCHAR2(80);
1450:
1451: CURSOR get_custom_process IS
1452: select meaning
1453: from WSH_LOOKUPS where lookup_type = p_wf_process and lookup_code = p_org_code
1454: and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
1455: and enabled_flag='Y';
1456:
1457: CURSOR get_gen_custom_process IS

Line 1459: from WSH_LOOKUPS where lookup_type = p_wf_process and lookup_code = 'ALL'

1455: and enabled_flag='Y';
1456:
1457: CURSOR get_gen_custom_process IS
1458: select meaning
1459: from WSH_LOOKUPS where lookup_type = p_wf_process and lookup_code = 'ALL'
1460: and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
1461: and enabled_flag='Y';
1462:
1463: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CUSTOM_WF_PROCESS';