DBA Data[Home] [Help]

APPS.JTF_RESOURCE_UTL dependencies on FND_USER

Line 1092: l_user_id fnd_user.user_id%TYPE;

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

Line 1097: FROM fnd_user

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