DBA Data[Home] [Help]

APPS.UMX_LOGIN_HELP_PVT dependencies on HZ_PARTIES

Line 215: FROM hz_parties hzp, fnd_user fu

211: AND nvl(end_date, sysdate + 1) > sysdate;
212:
213: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
214: SELECT hzp.email_address
215: FROM hz_parties hzp, fnd_user fu
216: WHERE hzp.party_id = fu.person_party_id
217: AND fu.user_name = p_user_name;
218:
219: begin

Line 286: FROM hz_parties p, fnd_user fu

282:
283:
284: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
285: SELECT fu.user_name
286: FROM hz_parties p, fnd_user fu
287: WHERE p.party_id = fu.person_party_id
288: AND p.email_address = p_email_address;
289:
290:

Line 360: FROM hz_parties p, fnd_user fu

356:
357:
358: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
359: SELECT fu.user_name
360: FROM hz_parties p, fnd_user fu
361: WHERE p.party_id = fu.person_party_id
362: AND UPPER(p.email_address) = UPPER(p_email_address);
363:
364: