DBA Data[Home] [Help]

APPS.AS_AUTOCREATE_OPP dependencies on FND_USER

Line 47: ,JTF_RS_ROLES_B roleb, FND_User fnd_user

43:
44: Cursor C_GetIdentity_FndUser(p_user_id Number) IS
45: Select force.resource_id
46: From JTF_RS_RESOURCE_EXTNS force, JTF_RS_ROLE_RELATIONS rrel
47: ,JTF_RS_ROLES_B roleb, FND_User fnd_user
48: Where force.user_id = fnd_user.user_id
49: and fnd_user.user_id = p_user_id
50: and force.category in ('EMPLOYEE','PARTY')
51: and force.resource_id = rrel.role_resource_id

Line 48: Where force.user_id = fnd_user.user_id

44: Cursor C_GetIdentity_FndUser(p_user_id Number) IS
45: Select force.resource_id
46: From JTF_RS_RESOURCE_EXTNS force, JTF_RS_ROLE_RELATIONS rrel
47: ,JTF_RS_ROLES_B roleb, FND_User fnd_user
48: Where force.user_id = fnd_user.user_id
49: and fnd_user.user_id = p_user_id
50: and force.category in ('EMPLOYEE','PARTY')
51: and force.resource_id = rrel.role_resource_id
52: and rrel.role_resource_type = 'RS_INDIVIDUAL'

Line 49: and fnd_user.user_id = p_user_id

45: Select force.resource_id
46: From JTF_RS_RESOURCE_EXTNS force, JTF_RS_ROLE_RELATIONS rrel
47: ,JTF_RS_ROLES_B roleb, FND_User fnd_user
48: Where force.user_id = fnd_user.user_id
49: and fnd_user.user_id = p_user_id
50: and force.category in ('EMPLOYEE','PARTY')
51: and force.resource_id = rrel.role_resource_id
52: and rrel.role_resource_type = 'RS_INDIVIDUAL'
53: and rrel.role_id = roleb.role_id