APPS.CSI_RMA_RECEIPT_PUB dependencies on HZ_CUST_ACCOUNTS

Line 357: l_account_status hz_cust_accounts.status%type;

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

Line 404: FROM hz_cust_accounts

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

Line 486: FROM hz_cust_accounts

482: debug(' Original Return Quantity: '||x_src_order_rec.original_order_qty);
483: IF x_src_order_rec.customer_account_id IS NOT NULL THEN
484: SELECT party_id
485: INTO x_src_order_rec.party_id
486: FROM hz_cust_accounts
487: WHERE cust_account_id = x_src_order_rec.customer_account_id;
488: END IF;
489: 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
490: IF l_cust_acct_site_use_id IS NOT NULL THEN