APPS.FV_FACTS_TRANSACTIONS dependencies on FV_PYA_FISCALYEAR_MAP

Line 310: FROM fv_pya_fiscalyear_map

306: sob := p_ledger_id;
307:
308: SELECT count(*)
309: INTO vl_fiscalyear_count
310: FROM fv_pya_fiscalyear_map
311: WHERE set_of_books_id = sob;
312:
313: -- Check whether program reporting code mapping has
314: -- been done for set of books. If not, then write error

Line 1202: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;

1198: vl_ec_retcode NUMBER := 0 ;
1199: vl_ec_errbuf VARCHAR2(400) ;
1200: vl_req_id NUMBER ;
1201: vl_disbursements_flag VARCHAR2(1);
1202: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%TYPE;
1203:
1204: vl_je_source gl_je_headers.je_source%TYPE;
1205: vl_pl_code VARCHAR2(150);
1206: vl_tr_main_acct VARCHAR2(150);

Line 1604: FROM fv_pya_fiscalyear_map

1600: THEN
1601: BEGIN
1602: SELECT fyr_segment_value
1603: INTO vl_fyr_segment_value
1604: FROM fv_pya_fiscalyear_map
1605: WHERE period_year = vp_report_fiscal_yr
1606: AND set_of_books_id = vp_set_of_books_id;
1607: EXCEPTION
1608: WHEN NO_DATA_FOUND THEN