APPS.FV_FACTS_TRX_REGISTER dependencies on FV_BE_TRX_HDRS

Line 2572: FROM fv_be_trx_hdrs h,

2568: DECLARE
2569: --Modified for bug 7256357
2570: CURSOR dept_cur IS
2571: SELECT h.doc_number, d.dept_id||d.main_account
2572: FROM fv_be_trx_hdrs h,
2573: fv_be_trx_dtls d
2574: WHERE d.transaction_id = to_number(l_reference_1)
2575: AND h.doc_id = d.doc_id;
2576: --SELECT dept_id||main_account

Line 2579: l_doc_number fv_be_trx_hdrs.doc_number%TYPE;

2575: AND h.doc_id = d.doc_id;
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,

Line 3317: FROM fv_be_trx_dtls d, fv_be_trx_hdrs h

3313: AND api.invoice_id = apip.invoice_id;
3314: CURSOR Budget_Transac IS
3315: SELECT h.doc_number, d.gl_date, d.creation_date,
3316: d.created_by
3317: FROM fv_be_trx_dtls d, fv_be_trx_hdrs h
3318: WHERE d.transaction_id = to_number(p_reference1)
3319: AND h.doc_id = d.doc_id;
3320: /*
3321: CURSOR Pur_Req IS