APPS.FV_FACTS_TRX_REGISTER dependencies on FV_BE_TRX_DTLS

Line 88: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;

84: g_balance_type_val VARCHAR2(1) ;
85: g_advance_type_val VARCHAR2(1) ;
86: g_transfer_ind VARCHAR2(1) ;
87: g_year_budget_auth VARCHAR2(6) ;
88: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;
89: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;
90: g_availability_val VARCHAR2(6) ;
91: --g_prn_num VARCHAR2(3);
92: --g_prn_txt VARCHAR2(25);

Line 89: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;

85: g_advance_type_val VARCHAR2(1) ;
86: g_transfer_ind VARCHAR2(1) ;
87: g_year_budget_auth VARCHAR2(6) ;
88: g_transfer_dept_id fv_be_trx_dtls.dept_id%TYPE ;
89: g_transfer_main_acct fv_be_trx_dtls.main_account%TYPE ;
90: g_availability_val VARCHAR2(6) ;
91: --g_prn_num VARCHAR2(3);
92: --g_prn_txt VARCHAR2(25);
93:

Line 889: l_tran_type fv_be_trx_dtls.transaction_type_id%TYPE;

885: l_cbs_num VARCHAR2(3);
886:
887: l_exists VARCHAR2(1);
888: i NUMBER := 0;
889: l_tran_type fv_be_trx_dtls.transaction_type_id%TYPE;
890:
891: l_pl_code_col VARCHAR2(25);
892: l_advance_type_col VARCHAR2(25);
893: l_tr_dept_id_col VARCHAR2(25);

Line 2573: fv_be_trx_dtls d

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
2577: --FROM fv_be_trx_dtls

Line 2577: --FROM fv_be_trx_dtls

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
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

Line 2750: FROM fv_be_trx_dtls

2746: THEN
2747: BEGIN
2748: SELECT public_law_code
2749: INTO g_public_law_code_val
2750: FROM fv_be_trx_dtls
2751: WHERE transaction_id = to_number(l_reference_1)
2752: AND set_of_books_id = g_set_of_books_id ;
2753: EXCEPTION
2754: WHEN NO_DATA_FOUND THEN NULL;

Line 2784: FROM Fv_be_trx_dtls

2780: IF g_legis_Ind_flag = 'Y' THEN
2781: BEGIN
2782: SELECT transaction_type_id
2783: INTO l_tran_type
2784: FROM Fv_be_trx_dtls
2785: WHERE transaction_id = to_number(l_reference_1)
2786: AND set_of_books_id = g_set_of_books_id ;
2787:
2788: -- Get the Legislation Indicator Value from

Line 2814: FROM fv_be_trx_dtls

2810: THEN
2811: BEGIN
2812: SELECT advance_type
2813: INTO g_advance_type_val
2814: FROM fv_be_trx_dtls
2815: WHERE transaction_id = to_number(l_reference_1)
2816: AND set_of_books_id = g_set_of_books_id ;
2817: -- IF the advance_type value is null then set it to 'X'
2818: IF g_advance_type_val IS NULL THEN

Line 2858: FROM fv_be_trx_dtls

2854: SELECT dept_id,
2855: main_account
2856: INTO g_transfer_dept_id,
2857: g_transfer_main_acct
2858: FROM fv_be_trx_dtls
2859: WHERE transaction_id = to_number(l_reference_1)
2860: AND set_of_books_id = g_set_of_books_id ;
2861:
2862: -- IF the Transfer values are null then set default values

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