APPS.PO_WF_PO_NOTIFICATION dependencies on HZ_PARTIES

Line 1050: l_vendor_name hz_parties.party_name%TYPE;

1046: prior_len NUMBER := 0;
1047:
1048: /* Bug 2788683 start */
1049: l_user_name fnd_user.user_name%TYPE;
1050: l_vendor_name hz_parties.party_name%TYPE;
1051: l_party_name hz_parties.party_name%TYPE;
1052: /* Bug 2788683 end */
1053:
1054:

Line 1051: l_party_name hz_parties.party_name%TYPE;

1047:
1048: /* Bug 2788683 start */
1049: l_user_name fnd_user.user_name%TYPE;
1050: l_vendor_name hz_parties.party_name%TYPE;
1051: l_party_name hz_parties.party_name%TYPE;
1052: /* Bug 2788683 end */
1053:
1054:
1055: BEGIN

Line 1236: hz_parties hp

1232: hp.party_name
1233: INTO l_user_name,
1234: l_party_name
1235: FROM fnd_user fu,
1236: hz_parties hp
1237: WHERE hp.party_id = fu.customer_id
1238: AND fu.user_id = l_created_by_tbl(i);
1239:
1240: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);

Line 1311: hz_parties hp

1307: IF l_employee_id_tbl(i) IS NULL THEN
1308: SELECT fu.user_name, hp.party_name
1309: INTO l_user_name, l_party_name
1310: FROM fnd_user fu,
1311: hz_parties hp
1312: WHERE hp.party_id = fu.customer_id
1313: AND fu.user_id = l_created_by_tbl(i);
1314:
1315: po_inq_sv.get_vendor_name(l_user_name => l_user_name, x_vendor_name => l_vendor_name);