DBA Data[Home] [Help]

APPS.PV_OPP_MATCH_PUB dependencies on FND_USER

Line 1345: FROM fnd_user a, jtf_rs_resource_extns b

1341: -- ------------------------------------------------------------------------
1342: IF (p_resource_id IS NULL) THEN
1343: SELECT resource_id
1344: INTO l_resource_id
1345: FROM fnd_user a, jtf_rs_resource_extns b
1346: WHERE a.user_id = b.user_id AND
1347: a.user_name = p_user_name;
1348: ELSE
1349: l_resource_id := p_resource_id;

Line 1920: FROM fnd_user a, jtf_rs_resource_extns b

1916: -- -------------------------------------------------------------
1917: IF (p_user_name IS NULL) THEN
1918: SELECT a.user_name
1919: INTO l_user_name
1920: FROM fnd_user a, jtf_rs_resource_extns b
1921: WHERE b.resource_id = p_resource_id AND
1922: a.user_id = b.user_id;
1923:
1924: ELSE