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 1728: select person_party_id from fnd_user -- For Bug 4527617.

1724: p_user_id in number )
1725: return number
1726: IS
1727: Cursor external is
1728: select person_party_id from fnd_user -- For Bug 4527617.
1729: where user_id = p_user_id;
1730:
1731: Cursor internal is
1732: select h.party_id

Line 1734: ,fnd_user f

1730:
1731: Cursor internal is
1732: select h.party_id
1733: from hz_parties h
1734: ,fnd_user f
1735: where h.orig_system_reference = CONCAT('PER:',f.employee_id)
1736: and f.user_id = p_user_id;
1737:
1738: l_party_id number;