APPS.WSH_WF_STD dependencies on WSH_LOOKUPS

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

1429: -- x_wf_process - Returns the custom process name specified
1430: -- with the lookups else the orginial process
1431: -- x_return_status - Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
1432: --
1433: -- Description: This Procedure queries from the WSH_LOOKUPS for any custom
1434: -- process name specified by the User through the lookups for
1435: -- a particular process else returns the original process
1436: ---------------------------------------------------------------------------------------
1437:

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

1443: l_custom_process VARCHAR2(80);
1444:
1445: CURSOR get_custom_process IS
1446: select meaning
1447: from WSH_LOOKUPS where lookup_type = p_wf_process and lookup_code = p_org_code
1448: and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
1449: and enabled_flag='Y';
1450:
1451: CURSOR get_gen_custom_process IS

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

1449: and enabled_flag='Y';
1450:
1451: CURSOR get_gen_custom_process IS
1452: select meaning
1453: from WSH_LOOKUPS where lookup_type = p_wf_process and lookup_code = 'ALL'
1454: and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
1455: and enabled_flag='Y';
1456:
1457: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_CUSTOM_WF_PROCESS';