APPS.FV_FACTS_TBAL_TRX dependencies on FV_PYA_FISCALYEAR_MAP

Line 2505: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;

2501: v_excptn_cat fv_facts_temp.fct_int_record_category%TYPE;
2502: vl_enabled_flag fv_facts_ussgl_accounts.ussgl_enabled_flag%TYPE;
2503: vl_reporting_type fv_facts_ussgl_accounts.reporting_type%TYPE;
2504: */
2505: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
2506: vl_parent_sgl_acct_num fv_facts_temp.parent_sgl_acct_number%TYPE;
2507: vl_reimb_agree_sel VARCHAR2(250);
2508: vl_reimb_agree_seg_val VARCHAR2(30);
2509:

Line 2551: FROM fv_pya_fiscalyear_map

2547: v_period_dr <> 0 OR
2548: v_period_cr <> 0 )) THEN
2549:
2550: SELECT fyr_segment_value INTO vl_fyr_segment_value
2551: FROM fv_pya_fiscalyear_map
2552: WHERE period_year = vp_report_fiscal_yr
2553: AND set_of_books_id = vp_set_of_books_id;
2554:
2555: IF vl_fyr_segment_value IS NOT NULL THEN