DBA Data[Home] [Help]

APPS.JTF_UM_FORGOT_PASSWD dependencies on HZ_PARTIES

Line 333: from hz_parties hzp, fnd_user fu

329: where user_name = l_user_name;
330:
331: cursor c_party_email is
332: select hzp.email_address
333: from hz_parties hzp, fnd_user fu
334: where hzp.party_id = fu.customer_id
335: and fu.user_name = l_user_name;
336:
337: begin

Line 477: from hz_parties hzp, fnd_user fu

473: and wfa.text_value = p_name;
474:
475: cursor c_party_email is
476: select hzp.email_address
477: from hz_parties hzp, fnd_user fu
478: where hzp.party_id = fu.customer_id
479: and fu.user_name = p_name;
480:
481: begin

Line 644: from hz_parties hzp, fnd_user fu

640: and wfa.text_value = p_name;
641:
642: cursor c_party_email is
643: select hzp.email_address
644: from hz_parties hzp, fnd_user fu
645: where hzp.party_id = fu.customer_id
646: and fu.user_name = p_name;
647:
648: begin