[Home] [Help]
1080: gl_je_headers gjh,
1081: gl_je_lines gjl,
1082: gl_code_combinations glc,
1083: fv_treasury_symbols fts,
1084: fv_fund_parameters ffp
1085: WHERE gjl.code_combination_id = glc.code_combination_id
1086: AND gjl.ledger_id = :sob_id
1087: AND glc.chart_of_accounts_id= :coa_id
1088: AND gjh.je_header_id = gjl.je_header_id
1155: gl_je_headers gjh,
1156: gl_je_lines gjl,
1157: gl_code_combinations glc,
1158: fv_treasury_symbols fts,
1159: fv_fund_parameters ffp,
1160: xla_ae_lines xal,
1161: xla_ae_headers xah,
1162: xla_distribution_links xdl,
1163: gl_import_references gir
4067: -- --------------------------------------------------------------------
4068: -- PROCEDURE GET_FUND_GROUP_INFO
4069: -- --------------------------------------------------------------------
4070: -- Its primary purpose get the fund Group, Dept Id, bureau Id and
4071: -- balancing segment from the fv_fund_parameters table for the
4072: -- passed Code Combination Id.
4073: -- --------------------------------------------------------------------
4074: PROCEDURE get_fund_group_info (p_ccid gl_balances.code_combination_id%TYPE,
4075: p_fund_group IN OUT NOCOPY VARCHAR2,
4095:
4096: l_fund_select := 'SELECT ''X'', fts.fund_group_code, fts.department_id, ' ||
4097: 'fts.bureau_id, ' ||
4098: 'glc.' || g_bal_segment_name || ' ' ||
4099: 'FROM gl_code_combinations glc, fv_fund_parameters ffp, ' ||
4100: 'fv_treasury_symbols fts ' ||
4101: 'WHERE glc.code_combination_id = :ccid
4102: AND glc.chart_of_accounts_id = :coa_id
4103: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
4417: l_resource_type VARCHAR2(80) ;
4418: l_fund_category VARCHAR2(1) ;
4419: l_ussgl_enabled VARCHAR2(1) ;
4420: l_reporting_type VARCHAR2(1) ;
4421: l_budget_sub fv_fund_parameters.budget_subfunction %TYPE;
4422: l_cnc fv_treasury_symbols.cust_non_cust%TYPE;
4423: BEGIN
4424: l_module_name := g_module_name || 'load_facts_attributes';
4425: BEGIN
4487: INTO l_resource_type,
4488: g_def_indef_val,
4489: l_fund_category
4490: FROM fv_treasury_symbols fts,
4491: fv_fund_parameters ffp
4492: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
4493: AND ffp.fund_value = fund_val
4494: AND fts.treasury_symbol_id = g_treasury_symbol_id
4495: AND fts.set_of_books_id = g_set_of_books_id
4589: AND ffba.set_of_books_id = g_set_of_books_id ;
4590:
4591: SELECT RPAD(SUBSTR(bea_category,1,5), 5)
4592: INTO g_bea_category_val
4593: FROM fv_fund_parameters
4594: WHERE treasury_symbol_id = g_treasury_symbol_id
4595: AND set_of_books_id = g_set_of_books_id
4596: AND fund_category = l_fund_category;
4597:
4665: ----------------------------------------------
4666: IF (g_budget_subfunction_ind = 'Y') THEN
4667: SELECT budget_subfunction
4668: INTO l_budget_sub
4669: FROM fv_fund_parameters
4670: WHERE fund_value = FUND_VAL
4671: AND set_of_books_id = g_set_of_books_id;
4672:
4673: IF (l_budget_sub IS NOT NULL) THEN
4691: ----------------------------------------------
4692: IF (g_cust_non_cust_ind = 'Y') THEN
4693: SELECT fts.cust_non_cust
4694: INTO l_cnc
4695: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
4696: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
4697: AND ffp.set_of_books_id = g_set_of_books_id
4698: AND ffp.fund_value = fund_val;
4699:
4876:
4877: CURSOR fund_cur IS
4878: SELECT fund_value,
4879: DECODE(fund_category,'S','A','T','B',fund_category) fund_category
4880: FROM fv_fund_parameters ffp
4881: WHERE ffp.treasury_symbol_id = g_treasury_symbol_id
4882: AND ffp.set_of_books_id = g_set_of_books_id
4883: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
4884: