APPS.CSI_RMA_RECEIPT_PUB dependencies on HZ_CUST_ACCOUNTS

Line 356: l_account_status hz_cust_accounts.status%type;

352: X_return_status OUT NOCOPY varchar2)
353: IS
354:
355: l_party_id number;
356: l_account_status hz_cust_accounts.status%type;
357: l_rma_line_id number;
358:
359: BEGIN
360:

Line 403: FROM hz_cust_accounts

399: SELECT party_id,
400: status
401: INTO l_party_id,
402: l_account_status
403: FROM hz_cust_accounts
404: WHERE cust_account_id = x_partner_order_rec.END_CUSTOMER_ID;
405: EXCEPTION
406: WHEN no_data_found THEN
407: fnd_message.set_name('CSI','CSI_INT_INV_CUST_ACCT_ID');

Line 485: FROM hz_cust_accounts

481: debug(' Original Return Quantity: '||x_src_order_rec.original_order_qty);
482: IF x_src_order_rec.customer_account_id IS NOT NULL THEN
483: SELECT party_id
484: INTO x_src_order_rec.party_id
485: FROM hz_cust_accounts
486: WHERE cust_account_id = x_src_order_rec.customer_account_id;
487: END IF;
488: l_cust_acct_site_use_id := nvl(l_ship_to_org, l_invoice_to_org); -- Invoice to is to be not null in RMA's - Self bug. shegde
489: IF l_cust_acct_site_use_id IS NOT NULL THEN