[Home] [Help]
1123: gl_je_headers gjh,
1124: gl_je_lines gjl,
1125: gl_code_combinations glc,
1126: fv_treasury_symbols fts,
1127: fv_fund_parameters ffp
1128: WHERE gjl.code_combination_id = glc.code_combination_id
1129: AND gjl.ledger_id = :sob_id
1130: AND glc.chart_of_accounts_id= :coa_id
1131: AND gjh.je_header_id = gjl.je_header_id
1199: gl_je_headers gjh,
1200: gl_je_lines gjl,
1201: gl_code_combinations glc,
1202: fv_treasury_symbols fts,
1203: fv_fund_parameters ffp,
1204: xla_ae_lines xal,
1205: xla_ae_headers xah,
1206: xla_distribution_links xdl,
1207: gl_import_references gir
4286: -- --------------------------------------------------------------------
4287: -- PROCEDURE GET_FUND_GROUP_INFO
4288: -- --------------------------------------------------------------------
4289: -- Its primary purpose get the fund Group, Dept Id, bureau Id and
4290: -- balancing segment from the fv_fund_parameters table for the
4291: -- passed Code Combination Id.
4292: -- --------------------------------------------------------------------
4293: PROCEDURE get_fund_group_info (p_ccid gl_balances.code_combination_id%TYPE,
4294: p_fund_group IN OUT NOCOPY VARCHAR2,
4320:
4321: l_fund_select := 'SELECT ''X'', fts.fund_group_code, fts.department_id, ' ||
4322: 'fts.bureau_id, ' ||
4323: 'glc.' || g_bal_segment_name || ' ' ||
4324: 'FROM gl_code_combinations glc, fv_fund_parameters ffp, ' ||
4325: 'fv_treasury_symbols fts ' ||
4326: 'WHERE glc.code_combination_id = :ccid
4327: AND glc.chart_of_accounts_id = :coa_id
4328: AND ffp.treasury_symbol_id = fts.treasury_symbol_id
4663: l_resource_type VARCHAR2(80) ;
4664: l_fund_category VARCHAR2(1) ;
4665: l_ussgl_enabled VARCHAR2(1) ;
4666: l_reporting_type VARCHAR2(1) ;
4667: l_budget_sub fv_fund_parameters.budget_subfunction %TYPE;
4668: l_cnc fv_treasury_symbols.cust_non_cust%TYPE;
4669: BEGIN
4670: l_module_name := g_module_name || 'load_facts_attributes';
4671: BEGIN
4737: g_def_indef_val,
4738: l_fund_category,
4739: g_reimburseable_val
4740: FROM fv_treasury_symbols fts,
4741: fv_fund_parameters ffp
4742: WHERE ffp.treasury_symbol_id = fts.treasury_symbol_id
4743: AND ffp.fund_value = fund_val
4744: AND fts.treasury_symbol_id = g_treasury_symbol_id
4745: AND fts.set_of_books_id = g_set_of_books_id
4836: BEGIN
4837: SELECT RPAD(SUBSTR(borrowing_source_code,1,6), 6),
4838: RPAD(SUBSTR(bea_category,1,5), 5)
4839: INTO g_borrowing_source_val, g_bea_category_val
4840: FROM fv_fund_parameters
4841: WHERE fund_value= fund_val
4842: AND treasury_symbol_id = g_treasury_symbol_id
4843: AND set_of_books_id = g_set_of_books_id;
4844:
4857: AND ffba.set_of_books_id = g_set_of_books_id ;
4858:
4859: SELECT RPAD(SUBSTR(bea_category,1,5), 5)
4860: INTO g_bea_category_val
4861: FROM fv_fund_parameters
4862: WHERE treasury_symbol_id = g_treasury_symbol_id
4863: AND set_of_books_id = g_set_of_books_id
4864: AND fund_category = l_fund_category;
4865: */
4934: ----------------------------------------------
4935: IF (g_budget_subfunction_ind = 'Y') THEN
4936: SELECT budget_subfunction
4937: INTO l_budget_sub
4938: FROM fv_fund_parameters
4939: WHERE fund_value = FUND_VAL
4940: AND set_of_books_id = g_set_of_books_id;
4941:
4942: IF (l_budget_sub IS NOT NULL) THEN
4968: ----------------------------------------------
4969: IF (g_cust_non_cust_ind = 'Y') THEN
4970: SELECT fts.cust_non_cust
4971: INTO l_cnc
4972: FROM fv_treasury_symbols fts, fv_fund_parameters ffp
4973: WHERE fts.treasury_symbol_id = ffp.treasury_symbol_id
4974: AND ffp.set_of_books_id = g_set_of_books_id
4975: AND ffp.fund_value = fund_val;
4976:
5155:
5156: CURSOR fund_cur IS
5157: SELECT fund_value,
5158: DECODE(fund_category,'S','A','T','B',fund_category) fund_category
5159: FROM fv_fund_parameters ffp
5160: WHERE ffp.treasury_symbol_id = g_treasury_symbol_id
5161: AND ffp.set_of_books_id = g_set_of_books_id
5162: AND ffp.fund_category IN ('A', 'B', 'S', 'T');
5163: