APPS.PO_WF_REQ_NOTIFICATION dependencies on HZ_PARTIES

Line 1931: l_vendor_name hz_parties.party_name%TYPE;

1927: l_notification_id number;
1928:
1929: /* Bug 2788683 start */
1930: l_user_name fnd_user.user_name%TYPE;
1931: l_vendor_name hz_parties.party_name%TYPE;
1932: l_party_name hz_parties.party_name%TYPE;
1933: /* Bug 2788683 end */
1934:
1935: CURSOR count_rows(v_document_id NUMBER, v_object_type VARCHAR2) IS

Line 1932: l_party_name hz_parties.party_name%TYPE;

1928:
1929: /* Bug 2788683 start */
1930: l_user_name fnd_user.user_name%TYPE;
1931: l_vendor_name hz_parties.party_name%TYPE;
1932: l_party_name hz_parties.party_name%TYPE;
1933: /* Bug 2788683 end */
1934:
1935: CURSOR count_rows(v_document_id NUMBER, v_object_type VARCHAR2) IS
1936: SELECT count(*)

Line 2026: hz_parties hp

2022: IF l_history.employee_id IS NULL THEN
2023: SELECT fu.user_name, hp.party_name
2024: INTO l_user_name, l_party_name
2025: FROM fnd_user fu,
2026: hz_parties hp
2027: WHERE hp.party_id = fu.customer_id
2028: AND fu.user_id = l_history.created_by;
2029:
2030: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);

Line 2077: hz_parties hp

2073: IF l_history.employee_id IS NULL THEN
2074: SELECT fu.user_name, hp.party_name
2075: INTO l_user_name, l_party_name
2076: FROM fnd_user fu,
2077: hz_parties hp
2078: WHERE hp.party_id = fu.customer_id
2079: AND fu.user_id = l_history.created_by;
2080:
2081: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);