APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on FV_FUND_PARAMETERS

Line 693: FV_FUND_PARAMETERS FFP,

689: -- Get the balances for the Account Number and Fund Value
690: vl_main_select := 'SELECT DISTINCT GLCC.'||v_acc_seg_name||
691: ', GLCC.'||v_bal_seg_name||v_cohort_select||
692: ' FROM GL_CODE_COMBINATIONS GLCC,
693: FV_FUND_PARAMETERS FFP,
694: FV_TREASURY_SYMBOLS FTS
695: WHERE FTS.TREASURY_SYMBOL = ' ||''''||vp_treasury_symbol||'''' ||
696: --pkpatel :changed to fix Bug 1575992
697: ' AND FTS.TREASURY_SYMBOL_ID = FFP.TREASURY_SYMBOL_ID

Line 1027: fv_fund_parameters ffp

1023: gl_je_headers glh,
1024: gl_je_batches glb,
1025: gl_je_categories glc,
1026: gl_code_combinations glcc,
1027: fv_fund_parameters ffp
1028: Where gjl.code_combination_id = glcc.code_combination_id
1029: and gjl.Period_Name NOT IN (Select Period_Name From GL_Period_Statuses
1030: Where Adjustment_Period_Flag = '||''''||'Y'||''''||
1031: ' And set_of_books_id = ' || vp_set_of_books_id || ')

Line 1749: fv_fund_parameters ffp

1745: INTO vl_resource_type,
1746: va_def_indef_val,
1747: vl_fund_category
1748: From fv_treasury_symbols fts,
1749: fv_fund_parameters ffp
1750: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
1751: AND ffp.fund_value = fund_val
1752: AND fts.treasury_symbol = vp_treasury_symbol
1753: AND fts.set_of_books_id = vp_set_of_books_id