DBA Data[Home] [Help]

APPS.FV_FACTS_TRANSACTIONS dependencies on FV_PYA_FISCALYEAR_SEGMENT

Line 897: FROM fv_pya_fiscalyear_segment

893:
894: -- Getting Fiscal year segment name from fv_pya_fiscal_year_segment
895: SELECT application_column_name
896: INTO v_fyr_segment_name
897: FROM fv_pya_fiscalyear_segment
898: WHERE set_of_books_id = vp_set_of_books_id;
899: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
900: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
901: 'Fiscal year segment: '||v_fyr_segment_name);

Line 958: fv_pya_fiscalyear_segment fpfs

954: vc_dept_transfer
955: FROM
956: fv_facts_federal_accounts fffa,
957: fv_treasury_symbols fts,
958: fv_pya_fiscalyear_segment fpfs
959: WHERE fffa.federal_acct_symbol_id = fts.federal_acct_symbol_id
960: AND fts.treasury_symbol = vp_treasury_symbol
961: AND fts.set_of_books_id = vp_set_of_books_id
962: AND fffa.set_of_books_id = vp_set_of_books_id