APPS.FUN_WF_COMMON dependencies on FND_USER

Line 1151: p_user_id - fnd_user.userid of the person navigating

1147: whether or not the user the notification is going to be sent to
1148: is a valid user or not.
1149: Parameters:
1150: IN : p_transaction_id - fun_trx_headers.trx_id
1151: p_user_id - fnd_user.userid of the person navigating
1152: to the Inbound Trx UI.
1153: p_role_name - wf_roles.name of the person the notification
1154: is being sent to or forwarded to.
1155: p_org_type = 'I' Initiating, 'R' Recipient.

Line 1172: FROM fnd_user usr,

1168: RETURN VARCHAR2 IS
1169:
1170: CURSOR c_chk_user IS
1171: SELECT 'X'
1172: FROM fnd_user usr,
1173: WF_USER_ROLE_ASSIGNMENTS role
1174: WHERE usr.user_id = p_user_id
1175: AND usr.user_name = role.user_name
1176: AND role.role_name = 'FUN_ADHOC_RECI_'||p_transaction_id;

Line 1181: fnd_user fu,

1177: -- Bug No: 5897122
1178: CURSOR c_chk_web IS
1179: SELECT 'X'
1180: FROM hz_parties p,
1181: fnd_user fu,
1182: fun_trx_headers ftrx,
1183: hz_relationships hzr,
1184: hz_org_contacts hc,
1185: hz_org_contact_roles hcr

Line 1208: fnd_user wf,

1204: CURSOR c_chk_role IS
1205: SELECT 'X'
1206: FROM fun_trx_headers trx,
1207: hz_relationships rel,
1208: fnd_user wf,
1209: hz_org_contacts c,
1210: hz_org_contact_roles cr
1211: WHERE wf.user_name = p_role_name
1212: AND wf.person_party_id = rel.subject_id

Line 1228: l_user_name fnd_user.user_name%TYPE;

1224: AND c.party_relationship_id = rel.relationship_id
1225: AND cr.org_contact_id = c.org_contact_id
1226: AND cr.role_type = 'INTERCOMPANY_CONTACT_FOR';
1227:
1228: l_user_name fnd_user.user_name%TYPE;
1229:
1230: BEGIN
1231: IF p_mode = 'UI'
1232: THEN