APPS.RCV_RMA_HEADERS dependencies on HZ_PARTIES

Line 308: FROM hz_parties party,

304: IF p_header_record.header_record.customer_party_name IS NULL
305: AND p_header_record.header_record.customer_id IS NOT NULL THEN
306: SELECT party.party_name
307: INTO p_header_record.header_record.customer_party_name
308: FROM hz_parties party,
309: hz_cust_accounts acct
310: WHERE acct.party_id = party.party_id
311: AND acct.cust_account_id = p_header_record.header_record.customer_id;
312: END IF;

Line 329: FROM hz_parties party,

325: AND p_header_record.header_record.customer_account_number IS NOT NULL
326: AND p_header_record.header_record.customer_party_name IS NOT NULL THEN
327: SELECT acct.cust_account_id
328: INTO p_header_record.header_record.customer_id
329: FROM hz_parties party,
330: hz_cust_accounts acct
331: WHERE party.party_id = acct.party_id
332: AND party.party_name = p_header_record.header_record.customer_party_name
333: AND acct.account_number = p_header_record.header_record.customer_account_number;

Line 379: -- from hz_parties party, hz_cust_accounts acct

375: -- end if;
376:
377: -- If (customer_id is null and (party_name is not null) then
378: -- select count(*)
379: -- from hz_parties party, hz_cust_accounts acct
380: -- where acct.party_id = party.party_id and
381: -- party.party_name = party_name;
382:
383: -- If (l_count = 1) then /* There is only one acct for this party hence default*/

Line 385: -- from hz_parties party, hz_cust_accounts acct

381: -- party.party_name = party_name;
382:
383: -- If (l_count = 1) then /* There is only one acct for this party hence default*/
384: -- select acct.cust_account_id
385: -- from hz_parties party, hz_cust_accounts acct
386: -- where acct.party_id = party.party_id and
387: -- party.party_name = party_name;
388: -- end if;
389: