APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on FV_PYA_FISCALYEAR_MAP

Line 83: v_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;

79: va_user_category GL_JE_CATEGORIES.USER_JE_CATEGORY_NAME%TYPE;
80: v_doc_created_by NUMBER(15) ;
81: v_doc_creation_date DATE ;
82: v_ccid GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE;
83: v_seg_fiscal_yr fv_pya_fiscalyear_map.fyr_segment_value%type;
84:
85: -- ======================================================================
86: -- FACTS File Constants
87: -- ======================================================================

Line 613: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;

609: vl_seg_value_set_name VARCHAR2(40) ;
610: vl_disbursements_flag VARCHAR2(1);
611: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
612: v_excptn_cat fv_facts_temp.fct_int_record_category%TYPE;
613: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
614: v_fyr_segment_name VARCHAR2(20) ;
615: --v_financing_acct VARCHAR2(1);
616: P_refer2 VARCHAR2(80);
617:

Line 1542: FROM fv_pya_fiscalyear_map

1538: BEGIN
1539:
1540: SELECT fyr_segment_value
1541: INTO vl_fyr_segment_value
1542: FROM fv_pya_fiscalyear_map
1543: WHERE period_year = v_fiscal_year
1544: AND set_of_books_id = vp_set_of_books_id;
1545:
1546: EXCEPTION