APPS.UMX_NOTIFICATION_UTIL dependencies on HZ_PARTIES

Line 226: l_requested_for_party_id hz_parties.party_id%type;

222: l_display_name wf_users.display_name%type;
223: l_next_approver ame_util.approverRecord2;
224: l_requested_for_user_id fnd_user.user_id%type;
225: l_registration_data wf_event_t;
226: l_requested_for_party_id hz_parties.party_id%type;
227: l_user_role_name wf_local_roles.name%type;
228: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
229: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
230: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 490: l_person_party_id hz_parties.party_id%type;

486: l_reg_service_type WF_ACTIVITY_ATTRIBUTES.text_default%type;
487: l_mins WF_ACTIVITY_ATTRIBUTES.number_default%type;
488: l_days WF_ACTIVITY_ATTRIBUTES.number_default%type;
489: l_registration_data wf_event_t;
490: l_person_party_id hz_parties.party_id%type;
491:
492: x_return_status varchar2 (10);
493: x_msg_count number;
494: x_msg_data varchar2 (280);

Line 504: from fnd_user fu, hz_parties hzp

500: cursor get_username_from_userid (p_user_id in number) is
501: select fu.user_name, fu.email_address, hzp.Person_first_name,
502: hzp.Person_last_name, hzp.Person_middle_name, hzp.person_Name_suffix,
503: hzp.person_pre_name_adjunct
504: from fnd_user fu, hz_parties hzp
505: where fu.user_id = p_user_id
506: and hzp.party_id = fu.person_party_id;
507:
508: