APPS.FV_FACTS_TBAL_TRX dependencies on FV_PYA_FISCALYEAR_MAP

Line 2363: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;

2359: --
2360: l_module_name VARCHAR2(200) := g_module_name || 'CREATE_FACTS_RECORD';
2361: vl_disbursements_flag VARCHAR2(1);
2362: vl_exists Varchar2(1) ;
2363: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
2364: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
2365: v_excptn_cat fv_facts_temp.fct_int_record_category%TYPE;
2366: vl_parent_sgl_acct_num fv_facts_temp.parent_sgl_acct_number%TYPE;
2367: vl_enabled_flag fv_facts_ussgl_accounts.ussgl_enabled_flag%TYPE;

Line 2389: FROM fv_pya_fiscalyear_map

2385: v_period_dr <> 0 OR
2386: v_period_cr <> 0 )) THEN
2387:
2388: SELECT fyr_segment_value INTO vl_fyr_segment_value
2389: FROM fv_pya_fiscalyear_map
2390: WHERE period_year = vp_report_fiscal_yr
2391: AND set_of_books_id = vp_set_of_books_id;
2392:
2393: IF vl_fyr_segment_value IS NOT NULL THEN