1258: 'ATTRIBUTE14', C.ATTRIBUTE14,
1259: 'ATTRIBUTE15', C.ATTRIBUTE15) eliminations_id,
1260: c.account_name
1261: INTO l_vendor_type, l_elim_dept, l_recipient_name
1262: FROM hz_cust_accounts_all c
1263: WHERE c.cust_account_id = to_number(p_reference_7);
1264:
1265: l_cust_vend_type := 'C';
1266: ELSE
1922: c.account_name, other_source_rec.amount
1923: INTO p_party_info_tab(i).party_id, p_party_info_tab(i).vendor_type,
1924: p_party_info_tab(i).elim_dept, p_party_info_tab(i).recipient_name,
1925: P_party_info_tab(i).party_line_amount
1926: FROM hz_cust_accounts_all c
1927: WHERE c.cust_account_id = other_source_rec.party_id;
1928:
1929: p_party_info_tab(i).cust_vend_type := 'C';
1930: EXCEPTION WHEN NO_DATA_FOUND THEN
1927: WHERE c.cust_account_id = other_source_rec.party_id;
1928:
1929: p_party_info_tab(i).cust_vend_type := 'C';
1930: EXCEPTION WHEN NO_DATA_FOUND THEN
1931: FV_UTILITY.LOG_MESG('No data found in hz_cust_accounts_all for party_id: '||
1932: other_source_rec.party_id);
1933: p_party_info_tab(i).party_id := other_source_rec.party_id;
1934: p_party_info_tab(i).cust_vend_type := 'C';
1935: P_party_info_tab(i).party_line_amount := other_source_rec.amount;