APPS.FV_GTAS_TRX_REGISTER dependencies on FV_BE_TRX_DTLS

Line 97: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;

93: g_balance_type_val VARCHAR2(1) ;
94: g_advance_type_val VARCHAR2(1) ;
95: g_transfer_ind VARCHAR2(1) ;
96: g_year_budget_auth VARCHAR2(6) ;
97: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;
98: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;
99: g_availability_val VARCHAR2(6) ;
100:
101: g_gtas_attributes_setup BOOLEAN ;

Line 98: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;

94: g_advance_type_val VARCHAR2(1) ;
95: g_transfer_ind VARCHAR2(1) ;
96: g_year_budget_auth VARCHAR2(6) ;
97: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;
98: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;
99: g_availability_val VARCHAR2(6) ;
100:
101: g_gtas_attributes_setup BOOLEAN ;
102: g_src_flag VARCHAR2(1);

Line 3096: fv_be_trx_dtls d

3092: --Modified for bug 7256357
3093: CURSOR dept_cur IS
3094: SELECT h.doc_number, SUBSTR(d.dept_id,1,3), d.main_account
3095: FROM fv_be_trx_hdrs h,
3096: fv_be_trx_dtls d
3097: WHERE d.transaction_id = to_number(l_reference_1)
3098: AND h.doc_id = d.doc_id;
3099: --SELECT dept_id||main_account
3100: --FROM fv_be_trx_dtls

Line 3100: --FROM fv_be_trx_dtls

3096: fv_be_trx_dtls d
3097: WHERE d.transaction_id = to_number(l_reference_1)
3098: AND h.doc_id = d.doc_id;
3099: --SELECT dept_id||main_account
3100: --FROM fv_be_trx_dtls
3101: --WHERE transaction_id = to_number(l_reference_1);
3102: l_doc_number fv_be_trx_hdrs.doc_number%TYPE;
3103: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;
3104: BEGIN

Line 3476: FROM fv_be_trx_dtls d, fv_be_trx_hdrs h

3472:
3473: CURSOR Budget_Transac IS
3474: SELECT h.doc_number, d.gl_date, d.creation_date,
3475: d.created_by
3476: FROM fv_be_trx_dtls d, fv_be_trx_hdrs h
3477: WHERE d.transaction_id = to_number(p_reference1)
3478: AND h.doc_id = d.doc_id;
3479:
3480: CURSOR Manual IS

Line 5809: FROM fv_be_trx_dtls bd, fv_be_trx_hdrs bh, fv_budget_levels bl

5805: log(l_module,'l_be_trx_id: '||l_be_trx_id);
5806: BEGIN
5807: SELECT bd.TRANSACTION_TYPE_ID, bd.SUB_TYPE
5808: INTO l_trx_type_id, l_sub_type
5809: FROM fv_be_trx_dtls bd, fv_be_trx_hdrs bh, fv_budget_levels bl
5810: WHERE bd.transaction_id = l_be_trx_id
5811: AND bd.doc_id = bh.doc_id
5812: AND bd.set_of_books_id = bh.set_of_books_id
5813: AND bl.budget_level_id = bh.budget_level_id