APPS.FV_FACTS_TRX_REGISTER dependencies on HZ_CUST_ACCOUNTS_ALL

Line 2580: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;

2576: --SELECT dept_id||main_account
2577: --FROM fv_be_trx_dtls
2578: --WHERE transaction_id = to_number(l_reference_1);
2579: l_doc_number fv_be_trx_hdrs.doc_number%TYPE;
2580: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;
2581: BEGIN
2582: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2583: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2584: 'BUDGETARY TRANSACTION');

Line 5902: hz_cust_accounts_all hzca

5898: END IF;
5899: SELECT hzca.customer_class_code
5900: INTO l_cust_class_code
5901: FROM ra_customer_trx_all rct,
5902: hz_cust_accounts_all hzca
5903: WHERE rct.trx_number = p_reimb_agree_seg_val
5904: AND rct.set_of_books_id = g_set_of_books_id
5905: AND hzca.cust_account_id = rct.bill_to_customer_id;
5906:

Line 5945: hz_cust_accounts_all hzca

5941: END IF;
5942: SELECT hzca.customer_class_code
5943: INTO l_cust_class_code
5944: FROM ra_customer_trx_all rct,
5945: hz_cust_accounts_all hzca
5946: WHERE rct.trx_number = p_reimb_agree_seg_val
5947: AND rct.set_of_books_id = g_set_of_books_id
5948: AND hzca.cust_account_id = rct.bill_to_customer_id;
5949: