APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on HZ_PARTIES

Line 286: from Hz_Parties

282: if l_error_flag<>'Y' then
283: if l_THIRD_PARTY_TYPE = 'C' and l_THIRD_PARTY_NUMBER is not null then
284: select count(*)
285: into l_count
286: from Hz_Parties
287: where Party_Number =l_THIRD_PARTY_NUMBER;
288: if l_count=0 then
289: update ja_cn_item_interface
290: set status='ETP3'

Line 2406: from Hz_Parties

2402: exit when c_third_party%notfound;
2403: if l_third_party_type='C' then
2404: select party_id
2405: into l_third_party_id
2406: from Hz_Parties
2407: where Party_Number =l_THIRD_PARTY_NUMBER;
2408: elsif l_third_party_type='S' then
2409: select vendor_id
2410: into l_third_party_id