DBA Data[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on FND_RESPONSIBILITY

Line 1234: SELECT RESPONSIBILITY_ID INTO l_respId FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_KEY='OMFS_PALM';

1230: l_ret_acty_date DATE;
1231: l_max_mtl_items NUMBER;
1232: BEGIN
1233:
1234: SELECT RESPONSIBILITY_ID INTO l_respId FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_KEY='OMFS_PALM';
1235: l_ret_acty_date := sysdate - to_number(nvl(fnd_profile.value_specific('CSM_MULTI_RET_ACTY_DURATION',null,l_respId,null),90));
1236: l_max_mtl_items := to_number(nvl(fnd_profile.value_specific('CSM_MULTI_MAX_MTL_ITEMS',null,l_respId,null),500));
1237:
1238: