APPS.PO_WF_REQ_NOTIFICATION dependencies on HZ_PARTIES

Line 1930: l_vendor_name hz_parties.party_name%TYPE;

1926: l_notification_id number;
1927:
1928: /* Bug 2788683 start */
1929: l_user_name fnd_user.user_name%TYPE;
1930: l_vendor_name hz_parties.party_name%TYPE;
1931: l_party_name hz_parties.party_name%TYPE;
1932: /* Bug 2788683 end */
1933:
1934:

Line 1931: l_party_name hz_parties.party_name%TYPE;

1927:
1928: /* Bug 2788683 start */
1929: l_user_name fnd_user.user_name%TYPE;
1930: l_vendor_name hz_parties.party_name%TYPE;
1931: l_party_name hz_parties.party_name%TYPE;
1932: /* Bug 2788683 end */
1933:
1934:
1935: BEGIN

Line 2008: hz_parties hp

2004: IF l_history.employee_id IS NULL THEN
2005: SELECT fu.user_name, hp.party_name
2006: INTO l_user_name, l_party_name
2007: FROM fnd_user fu,
2008: hz_parties hp
2009: WHERE hp.party_id = fu.customer_id
2010: AND fu.user_id = l_history.created_by;
2011:
2012: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);

Line 2049: hz_parties hp

2045: IF l_history.employee_id IS NULL THEN
2046: SELECT fu.user_name, hp.party_name
2047: INTO l_user_name, l_party_name
2048: FROM fnd_user fu,
2049: hz_parties hp
2050: WHERE hp.party_id = fu.customer_id
2051: AND fu.user_id = l_history.created_by;
2052:
2053: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);