DBA Data[Home] [Help]

APPS.PA_UTILS dependencies on FND_USER

Line 189: fnd_user

185: employee_id
186: INTO
187: X_person_id
188: FROM
189: fnd_user
190: WHERE
191: user_id = X_userid;
192:
193: RETURN ( X_person_id );

Line 1484: select person_party_id from fnd_user -- For Bug 4527617.

1480: p_user_id in number )
1481: return number
1482: IS
1483: Cursor external is
1484: select person_party_id from fnd_user -- For Bug 4527617.
1485: where user_id = p_user_id;
1486:
1487: Cursor internal is
1488: select h.party_id

Line 1490: ,fnd_user f

1486:
1487: Cursor internal is
1488: select h.party_id
1489: from hz_parties h
1490: ,fnd_user f
1491: where h.orig_system_reference = CONCAT('PER:',f.employee_id)
1492: and f.user_id = p_user_id;
1493:
1494: l_party_id number;