APPS.FV_FACTS_TBAL_TRX dependencies on FV_FACTS_ATTRIBUTES

Line 143: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;

139: v_cohort_where Varchar2(120) ;
140: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;
141: /*
142: Commented by 7324248
143: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;
144: v_g_edit_check_code number(15);
145: v_acct_attr_flag Varchar2(1) ;
146: */
147: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;

Line 2008: -- segment from FV_FACTS_ATTRIBUTES table and load them into global

2004: -- -------------------------------------------------------------------
2005: -- PROCEDURE LOAD_FACTS_ATTRIBUTES
2006: -- -------------------------------------------------------------------
2007: -- This procedure selects the attributes for the Account number
2008: -- segment from FV_FACTS_ATTRIBUTES table and load them into global
2009: -- variables for usage in the FACTS Main process. It also calculates
2010: -- one time pull up values for the account number that does not
2011: -- require drill down into GL transactions.
2012: -- ------------------------------------------------------------------

Line 2070: FROM FV_FACTS_ATTRIBUTES

2066: va_deficiency_flag,
2067: va_function_flag,
2068: va_advance_flag,
2069: va_transfer_ind
2070: FROM FV_FACTS_ATTRIBUTES
2071: WHERE Facts_Acct_Number = acct_num
2072: and set_of_books_id = vp_set_of_books_id ;
2073:
2074: IF NOT v_year_gtn2001 THEN

Line 2224: -- Transaction Partner Value derived from FV_FACTS_ATTRIBUTES table

2220: Else
2221: va_authority_type_val := va_authority_type_flag ;
2222: End If ;
2223: --------------------------------------------------------------------
2224: -- Transaction Partner Value derived from FV_FACTS_ATTRIBUTES table
2225: --------------------------------------------------------------------
2226: --------------------------------------------------------------------
2227: --Commented for CGAC
2228: -- Deriving Reimburseable Flag Value

Line 2513: FROM fv_facts_attributes

2509:
2510: --Modifed for FV ER bug 8760767
2511:
2512: /* cursor vl_pya_cursor is SELECT decode(pya_flag,'Y','X',' ')
2513: FROM fv_facts_attributes
2514: WHERE ussgl_acct_number = v_sgl_acct_num;
2515: */
2516: /* Modified for CGAC */
2517: cursor vl_pya_cursor is SELECT decode(pya_flag,'N',' ',pya_flag)

Line 2518: FROM fv_facts_attributes

2514: WHERE ussgl_acct_number = v_sgl_acct_num;
2515: */
2516: /* Modified for CGAC */
2517: cursor vl_pya_cursor is SELECT decode(pya_flag,'N',' ',pya_flag)
2518: FROM fv_facts_attributes
2519: WHERE ussgl_acct_number = v_sgl_acct_num
2520: AND set_of_books_id=vp_set_of_books_id;
2521:
2522: BEGIN