DBA Data[Home] [Help]

APPS.FII_SETUP_VAL_C dependencies on FND_USER

Line 254: -- Retrieve fnd user ID from the username if it exists in fii_cc_mgr_sup_v

250:
251: -- Set a default value for l_user_id
252: l_user_id := -1;
253:
254: -- Retrieve fnd user ID from the username if it exists in fii_cc_mgr_sup_v
255: BEGIN
256: SELECT DISTINCT employee_id
257: INTO l_user_id
258: FROM fnd_user a,

Line 258: FROM fnd_user a,

254: -- Retrieve fnd user ID from the username if it exists in fii_cc_mgr_sup_v
255: BEGIN
256: SELECT DISTINCT employee_id
257: INTO l_user_id
258: FROM fnd_user a,
259: fii_cc_mgr_sup_v b
260: WHERE a.user_name = UPPER(p_user_name)
261: AND a.employee_id = b.id;
262: EXCEPTION