eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_CFS_PKG dependencies on FV_SBR_DEFINITIONS_ACCTS

Line 99: v_balance_type fv_sbr_definitions_accts.SBR_BALANCE_TYPE%TYPE;

95: v_cy_sbr_end_bal NUMBER;
96: v_py_sbr_beg_bal NUMBER;
97: v_py_sbr_end_bal NUMBER;
98: v_year_flag VARCHAR2(1):='P'; /* It represent current year(C) or previous year(P)*/
99: v_balance_type fv_sbr_definitions_accts.SBR_BALANCE_TYPE%TYPE;
100: istotal_cal NUMBER;
101: /* ADDED FOR sbr ER */
102: /* START*/
103: g_chart_of_accounts_id gl_ledgers.chart_of_accounts_id%TYPE;

Line 156: c_sbr_line_acct_id fv_sbr_definitions_accts.sbr_line_acct_id%TYPE;

152: c_sbr_report_line_number fv_sbr_definitions_lines.sbr_report_line_number%TYPE;
153: c_sbr_gl_balance fv_sbr_definitions_lines.SBR_GL_BALANCE%TYPE;
154:
155: -- ---------- Balance Type Cursor Vaiables ---------
156: c_sbr_line_acct_id fv_sbr_definitions_accts.sbr_line_acct_id%TYPE;
157: c_sbr_balance_type fv_sbr_definitions_accts.sbr_balance_type%TYPE;
158: c_acct_number fv_sbr_definitions_accts.acct_number%TYPE;
159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;
160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;

Line 157: c_sbr_balance_type fv_sbr_definitions_accts.sbr_balance_type%TYPE;

153: c_sbr_gl_balance fv_sbr_definitions_lines.SBR_GL_BALANCE%TYPE;
154:
155: -- ---------- Balance Type Cursor Vaiables ---------
156: c_sbr_line_acct_id fv_sbr_definitions_accts.sbr_line_acct_id%TYPE;
157: c_sbr_balance_type fv_sbr_definitions_accts.sbr_balance_type%TYPE;
158: c_acct_number fv_sbr_definitions_accts.acct_number%TYPE;
159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;
160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;
161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;

Line 158: c_acct_number fv_sbr_definitions_accts.acct_number%TYPE;

154:
155: -- ---------- Balance Type Cursor Vaiables ---------
156: c_sbr_line_acct_id fv_sbr_definitions_accts.sbr_line_acct_id%TYPE;
157: c_sbr_balance_type fv_sbr_definitions_accts.sbr_balance_type%TYPE;
158: c_acct_number fv_sbr_definitions_accts.acct_number%TYPE;
159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;
160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;
161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;
162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;

Line 159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;

155: -- ---------- Balance Type Cursor Vaiables ---------
156: c_sbr_line_acct_id fv_sbr_definitions_accts.sbr_line_acct_id%TYPE;
157: c_sbr_balance_type fv_sbr_definitions_accts.sbr_balance_type%TYPE;
158: c_acct_number fv_sbr_definitions_accts.acct_number%TYPE;
159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;
160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;
161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;
162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;
163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;

Line 160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;

156: c_sbr_line_acct_id fv_sbr_definitions_accts.sbr_line_acct_id%TYPE;
157: c_sbr_balance_type fv_sbr_definitions_accts.sbr_balance_type%TYPE;
158: c_acct_number fv_sbr_definitions_accts.acct_number%TYPE;
159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;
160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;
161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;
162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;
163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;
164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;

Line 161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;

157: c_sbr_balance_type fv_sbr_definitions_accts.sbr_balance_type%TYPE;
158: c_acct_number fv_sbr_definitions_accts.acct_number%TYPE;
159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;
160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;
161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;
162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;
163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;
164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;
165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;

Line 162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;

158: c_acct_number fv_sbr_definitions_accts.acct_number%TYPE;
159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;
160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;
161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;
162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;
163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;
164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;
165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;
166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;

Line 163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;

159: c_direct_or_reimb_code fv_sbr_definitions_accts.direct_or_reimb_code%TYPE;
160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;
161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;
162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;
163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;
164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;
165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;
166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;
167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;

Line 164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;

160: c_apportionment_category_code fv_sbr_definitions_accts.apportionment_category_code%TYPE;
161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;
162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;
163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;
164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;
165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;
166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;
167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;
168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;

Line 165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;

161: c_category_b_code fv_sbr_definitions_accts.category_b_code%TYPE;
162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;
163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;
164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;
165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;
166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;
167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;
168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;
169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;

Line 166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;

162: c_prc_code fv_sbr_definitions_accts. prc_code%TYPE;
163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;
164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;
165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;
166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;
167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;
168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;
169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;
170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;

Line 167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;

163: c_advance_code fv_sbr_definitions_accts.advance_code%TYPE;
164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;
165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;
166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;
167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;
168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;
169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;
170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;
171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;

Line 168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;

164: c_availability_time fv_sbr_definitions_accts.availability_time%TYPE;
165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;
166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;
167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;
168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;
169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;
170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;
171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;
172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;

Line 169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;

165: c_bea_category_code fv_sbr_definitions_accts.bea_category_code%TYPE;
166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;
167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;
168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;
169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;
170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;
171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;
172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;
173: c_expiration_flag fv_sbr_definitions_accts.expiration_flag%TYPE;

Line 170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;

166: c_borrowing_source_code fv_sbr_definitions_accts.borrowing_source_code%TYPE;
167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;
168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;
169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;
170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;
171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;
172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;
173: c_expiration_flag fv_sbr_definitions_accts.expiration_flag%TYPE;
174: c_fund_type fv_sbr_definitions_accts.fund_type%TYPE;

Line 171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;

167: c_transaction_partner fv_sbr_definitions_accts.transaction_partner%TYPE;
168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;
169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;
170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;
171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;
172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;
173: c_expiration_flag fv_sbr_definitions_accts.expiration_flag%TYPE;
174: c_fund_type fv_sbr_definitions_accts.fund_type%TYPE;
175: c_financing_account_code fv_sbr_definitions_accts.financing_account_code%TYPE;

Line 172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;

168: c_year_of_budget_authority fv_sbr_definitions_accts.year_of_budget_authority%TYPE;
169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;
170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;
171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;
172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;
173: c_expiration_flag fv_sbr_definitions_accts.expiration_flag%TYPE;
174: c_fund_type fv_sbr_definitions_accts.fund_type%TYPE;
175: c_financing_account_code fv_sbr_definitions_accts.financing_account_code%TYPE;
176: exp_date DATE;

Line 173: c_expiration_flag fv_sbr_definitions_accts.expiration_flag%TYPE;

169: c_prior_year_adjustment fv_sbr_definitions_accts.prior_year_adjustment%TYPE;
170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;
171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;
172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;
173: c_expiration_flag fv_sbr_definitions_accts.expiration_flag%TYPE;
174: c_fund_type fv_sbr_definitions_accts.fund_type%TYPE;
175: c_financing_account_code fv_sbr_definitions_accts.financing_account_code%TYPE;
176: exp_date DATE;
177: beg_date DATE;

Line 174: c_fund_type fv_sbr_definitions_accts.fund_type%TYPE;

170: c_authority_type fv_sbr_definitions_accts.authority_type%TYPE;
171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;
172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;
173: c_expiration_flag fv_sbr_definitions_accts.expiration_flag%TYPE;
174: c_fund_type fv_sbr_definitions_accts.fund_type%TYPE;
175: c_financing_account_code fv_sbr_definitions_accts.financing_account_code%TYPE;
176: exp_date DATE;
177: beg_date DATE;
178: close_date DATE;

Line 175: c_financing_account_code fv_sbr_definitions_accts.financing_account_code%TYPE;

171: c_tafs_status fv_sbr_definitions_accts.tafs_status%TYPE;
172: c_availability_type fv_sbr_definitions_accts.availability_type%TYPE;
173: c_expiration_flag fv_sbr_definitions_accts.expiration_flag%TYPE;
174: c_fund_type fv_sbr_definitions_accts.fund_type%TYPE;
175: c_financing_account_code fv_sbr_definitions_accts.financing_account_code%TYPE;
176: exp_date DATE;
177: beg_date DATE;
178: close_date DATE;
179: whether_Exp VARCHAR2(1);

Line 186: c_sbr_additional_info fv_sbr_definitions_accts .sbr_additional_info%TYPE;

182: whether_Exp_SameYear VARCHAR2(1);
183: expiring_year NUMBER;
184: -- New variables declared by Narsimha.
185: c_sbr_apportion_amt NUMBER;
186: c_sbr_additional_info fv_sbr_definitions_accts .sbr_additional_info%TYPE;
187: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
188: /* c_sbr_column_amount NUMBER;
189: c_sbr_amount_not_shown fv_sbr_definitions_cols_temp.sbr_amount_not_shown%TYPE;
190: -- ---------- Output Report Line Column Data -------------

Line 271: FROM fv_sbr_definitions_accts

267: expiration_flag ,
268: fund_type ,
269: financing_account_code ,
270: sbr_treasury_symbol_id
271: FROM fv_sbr_definitions_accts
272: WHERE sbr_line_id = c_sbr_line_id
273: and set_of_books_id = v_sob;
274:
275: /* TREASURY SYMBOLS CURSOR */

Line 411: FROM fv_sbr_definitions_accts

407: FROM fv_sbr_definitions_lines
408: WHERE set_of_books_id = p_set_of_books_id;
409:
410: SELECT count(*) into l_count_acct
411: FROM fv_sbr_definitions_accts
412: WHERE set_of_books_id = p_set_of_books_id;
413:
414: if l_count=0 or l_count_acct=0 then
415: errbuf := 'No Setup data for Statement of Budgetary Resources';

Line 731: FROM fv_sbr_definitions_accts d,

727: segment27 ,
728: segment28 ,
729: segment29 ,
730: segment30
731: FROM fv_sbr_definitions_accts d,
732: fv_sbr_definitions_lines l
733: WHERE d.sbr_line_id = l.sbr_line_id
734: AND l.set_of_books_id = v_sob
735: ORDER BY 2;

Line 2878: availability_type_treas fv_sbr_definitions_accts.availability_type%TYPE;

2874: query_fetch_bal_bud VARCHAR2(8600);
2875: query_fetch_bal_nbfa VARCHAR2(8600);
2876: where_clause VARCHAR2(8600);
2877: financing_account_treas FV_FACTS_FEDERAL_ACCOUNTS.financing_account%TYPE;
2878: availability_type_treas fv_sbr_definitions_accts.availability_type%TYPE;
2879: fund_type_treas fv_treasury_symbols.fund_group_code%TYPE;
2880: group_by_clause VARCHAR2(50):= 'group by bud_col,nbfa_col';
2881:
2882:

Line 3134: query_fetch_bal_bud := 'select sum(nvl(amount,0)),acct.bud_col,acct.nbfa_col from fv_facts_temp fac, fv_sbr_definitions_accts acct

3130:
3131:
3132: IF( c_sbr_balance_type = 'B' OR c_sbr_balance_type = 'E') THEN
3133: IF(( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='D') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='C'))THEN
3134: query_fetch_bal_bud := 'select sum(nvl(amount,0)),acct.bud_col,acct.nbfa_col from fv_facts_temp fac, fv_sbr_definitions_accts acct
3135: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3136: AND acct.sbr_line_id = :cv_sbr_line_id
3137: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3138: AND acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3146: query_fetch_bal_bud := 'select sum(nvl(amount,0)*(-1)),acct.bud_col,acct.nbfa_col from fv_facts_temp fac, fv_sbr_definitions_accts acct

3142: AND begin_end = '''||c_sbr_balance_type||'''';
3143:
3144:
3145: elsif (( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='C') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='D') ) THEN
3146: query_fetch_bal_bud := 'select sum(nvl(amount,0)*(-1)),acct.bud_col,acct.nbfa_col from fv_facts_temp fac, fv_sbr_definitions_accts acct
3147: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3148: AND acct.sbr_line_id = :cv_sbr_line_id
3149: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3150: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3205: from fv_facts_temp fac, fv_sbr_definitions_accts acct

3201:
3202: query_fetch_bal_bud := ' select
3203: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) ),
3204: acct.bud_col,acct.nbfa_col
3205: from fv_facts_temp fac, fv_sbr_definitions_accts acct
3206: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3207: AND acct.sbr_line_id = :cv_sbr_line_id
3208: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3209: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3255: from fv_facts_temp fac, fv_sbr_definitions_accts acct

3251: elsif (( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='C') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='D'))THEN
3252: /*FOR BUD_COL*/
3253: query_fetch_bal_bud := ' select
3254: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) )*(-1),acct.bud_col,acct.nbfa_col
3255: from fv_facts_temp fac, fv_sbr_definitions_accts acct
3256: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3257: AND acct.sbr_line_id = :cv_sbr_line_id
3258: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3259: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3304: from fv_facts_temp fac, fv_sbr_definitions_accts acct

3300:
3301: elsif (( c_sbr_balance_type= 'ED') OR( c_sbr_balance_type= 'EC')) THEN -- bal type is ending debit or ending credit only
3302: /*FOR BUD COL */
3303: query_fetch_bal_bud := 'select sum(nvl(amount,0)),acct.bud_col,acct.nbfa_col
3304: from fv_facts_temp fac, fv_sbr_definitions_accts acct
3305: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3306: AND acct.sbr_line_id = :cv_sbr_line_id
3307: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3308: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3372: from fv_facts_temp fac, fv_sbr_definitions_accts acct

3368: elsif( (c_sbr_balance_type= 'E-BD') OR (c_sbr_balance_type='E-BC')) THEN -- bal type is end begin debit only
3369: /*FOR BUD_COL*/
3370: query_fetch_bal_bud := ' select
3371: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) ),acct.bud_col,acct.nbfa_col
3372: from fv_facts_temp fac, fv_sbr_definitions_accts acct
3373: where (acct.sbr_treasury_symbol_id is null or acct.sbr_treasury_symbol_id = :cv_treasury_symbol_id)
3374: AND acct.sbr_line_id = :cv_sbr_line_id
3375: AND acct.sbr_line_acct_id = :cv_sbr_line_acct_id
3376: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 3608: FROM fv_sbr_definitions_accts dets,

3604: /* v_fct1_attr_select :=
3605: ' SELECT SUM(NVL(DECODE(:cv_balance_type,
3606: ''B'', ROUND(NVL(fctbal.begin_balance,0),2),
3607: ''E'', ROUND(NVL(fctbal.balance_amount,0))),0) )
3608: FROM fv_sbr_definitions_accts dets,
3609: fv_sbr_definitions_lines fsdl ,
3610: fv_sbr_ccids_gt fvcc,
3611: fv_facts1_period_attributes fctbal
3612: WHERE dets.sbr_line_id = :cv_line_id

Line 3640: FROM fv_sbr_definitions_accts dets,

3636:
3637: v_fct1_sel := 'SELECT ROUND(SUM(NVL(ffrt.amount,0) ),2) ';
3638: v_fct1_rcpt_sel := v_fct1_sel || ' , ffrt.recipient_name ';
3639: l_temp1 := '
3640: FROM fv_sbr_definitions_accts dets,
3641: fv_sbr_ccids_gt fvcc,
3642: fv_facts1_period_balances_v ffrt
3643: WHERE dets.sbr_line_id = :cv_line_id
3644: AND dets.sbr_line_acct_id = :cv_line_detail_id

Line 3689: FROM fv_sbr_definitions_accts dets,

3685: ''E'', ROUND(NVL(SUM((NVL(glbal.begin_balance_dr,0) -
3686: NVL(glbal.begin_balance_cr,0)) +
3687: (NVL(glbal.period_net_dr,0) -
3688: NVL(glbal.period_net_cr,0))),0),2)),0)
3689: FROM fv_sbr_definitions_accts dets,
3690: fv_sbr_definitions_lines fsdl ,
3691: gl_code_combinations glc,
3692: gl_code_combinations glc1,
3693: gl_balances glbal

Line 3748: FROM fv_sbr_definitions_accts

3744: sbr_balance_type,
3745: bud_col,
3746: nbfa_col,
3747: acct_number
3748: FROM fv_sbr_definitions_accts
3749: WHERE sbr_line_id = v_line_id
3750: and set_of_books_id = v_sob;
3751:
3752: l_ignore INTEGER;