DBA Data[Home] [Help]

APPS.UMX_PASSWORD_PVT dependencies on HZ_PARTIES

Line 31: FROM hz_parties hzp, fnd_user fu

27: AND nvl(end_date, sysdate + 1) > sysdate;
28:
29: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
30: SELECT hzp.email_address
31: FROM hz_parties hzp, fnd_user fu
32: WHERE hzp.party_id = fu.person_party_id
33: AND fu.user_name = p_user_name;
34:
35: begin