DBA Data[Home] [Help]

APPS.HZ_MGD_MASS_UPDATE_MEDIATOR dependencies on HZ_CUST_ACCOUNTS

Line 96: , hz_cust_accounts hca

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:
100: x_party_name:=' ';

Line 129: , hz_cust_accounts hca

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:
133: x_cust_name:=l_cust_name||'('||l_cust_num||')';