DBA Data[Home] [Help]

APPS.JTF_RESOURCE_UTL dependencies on FND_USER

Line 1090: l_user_id fnd_user.user_id%TYPE;

1086: p_source_id IN NUMBER,
1087: x_return_status OUT NOCOPY VARCHAR2
1088: ) IS
1089:
1090: l_user_id fnd_user.user_id%TYPE;
1091:
1092: /* Removed 'WORKER' from the below code for bug # 3455951 */
1093: CURSOR c_user_id IS
1094: SELECT user_id

Line 1095: FROM fnd_user

1091:
1092: /* Removed 'WORKER' from the below code for bug # 3455951 */
1093: CURSOR c_user_id IS
1094: SELECT user_id
1095: FROM fnd_user
1096: WHERE decode(p_category, 'EMPLOYEE', EMPLOYEE_ID, 'PARTY', CUSTOMER_ID, 'SUPPLIER_CONTACT', SUPPLIER_ID, null) = p_source_id
1097: AND user_id = p_user_id;
1098:
1099: BEGIN