APPS.HZ_MGD_MASS_UPDATE_MEDIATOR dependencies on HZ_PARTIES

Line 52: l_cust_name hz_parties.party_name%TYPE;

48: , x_cust_name OUT NOCOPY VARCHAR2
49: , x_site_name OUT NOCOPY VARCHAR2
50: )
51: IS
52: l_cust_name hz_parties.party_name%TYPE;
53: l_cust_num hz_parties.party_number%TYPE;
54: l_site_name hz_cust_site_uses.location%TYPE;
55:
56: BEGIN

Line 53: l_cust_num hz_parties.party_number%TYPE;

49: , x_site_name OUT NOCOPY VARCHAR2
50: )
51: IS
52: l_cust_name hz_parties.party_name%TYPE;
53: l_cust_num hz_parties.party_number%TYPE;
54: l_site_name hz_cust_site_uses.location%TYPE;
55:
56: BEGIN
57:

Line 74: FROM hz_parties

70: SELECT
71: SUBSTRB(party_name,1,40)
72: INTO
73: x_party_name
74: FROM hz_parties
75: WHERE party_id=p_entity_id;
76:
77: x_cust_name:=' ';
78: x_site_name:=' ';

Line 95: hz_parties hp

91: INTO
92: l_cust_name
93: , l_cust_num
94: FROM
95: hz_parties hp
96: , hz_cust_accounts hca
97: WHERE hca.party_id=hp.party_id
98: AND hca.cust_account_id=p_entity_id;
99:

Line 128: hz_parties hp

124: INTO
125: l_cust_name
126: , l_cust_num
127: FROM
128: hz_parties hp
129: , hz_cust_accounts hca
130: WHERE hca.party_id=hp.party_id
131: AND hca.cust_account_id=p_cust_account_id;
132: