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_SF133_ONEYEAR dependencies on FV_SF133_DEFINITIONS_ACCTS

Line 82: c_acct_number fv_sf133_definitions_accts.acct_number%TYPE;

78:
79: -- New variable declared by pkpatel to fix Bug 1575992
80: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
81: --sf133 begin
82: c_acct_number fv_sf133_definitions_accts.acct_number%TYPE;
83: c_direct_or_reimb_code fv_sf133_definitions_accts.direct_or_reimb_code%TYPE;
84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;
85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;
86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;

Line 83: c_direct_or_reimb_code fv_sf133_definitions_accts.direct_or_reimb_code%TYPE;

79: -- New variable declared by pkpatel to fix Bug 1575992
80: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
81: --sf133 begin
82: c_acct_number fv_sf133_definitions_accts.acct_number%TYPE;
83: c_direct_or_reimb_code fv_sf133_definitions_accts.direct_or_reimb_code%TYPE;
84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;
85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;
86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;
87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;

Line 84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;

80: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
81: --sf133 begin
82: c_acct_number fv_sf133_definitions_accts.acct_number%TYPE;
83: c_direct_or_reimb_code fv_sf133_definitions_accts.direct_or_reimb_code%TYPE;
84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;
85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;
86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;
87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;
88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;

Line 85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;

81: --sf133 begin
82: c_acct_number fv_sf133_definitions_accts.acct_number%TYPE;
83: c_direct_or_reimb_code fv_sf133_definitions_accts.direct_or_reimb_code%TYPE;
84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;
85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;
86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;
87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;
88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;
89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;

Line 86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;

82: c_acct_number fv_sf133_definitions_accts.acct_number%TYPE;
83: c_direct_or_reimb_code fv_sf133_definitions_accts.direct_or_reimb_code%TYPE;
84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;
85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;
86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;
87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;
88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;
89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;
90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;

Line 87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;

83: c_direct_or_reimb_code fv_sf133_definitions_accts.direct_or_reimb_code%TYPE;
84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;
85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;
86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;
87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;
88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;
89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;
90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;
91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;

Line 88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;

84: c_apportionment_category_code fv_sf133_definitions_accts.apportionment_category_code%TYPE;
85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;
86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;
87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;
88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;
89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;
90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;
91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;
92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;

Line 89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;

85: c_category_b_code fv_sf133_definitions_accts.category_b_code%TYPE;
86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;
87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;
88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;
89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;
90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;
91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;
92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;
93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;

Line 90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;

86: c_prc_code fv_sf133_definitions_accts. prc_code%TYPE;
87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;
88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;
89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;
90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;
91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;
92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;
93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;
94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;

Line 91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;

87: c_advance_code fv_sf133_definitions_accts.advance_code%TYPE;
88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;
89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;
90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;
91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;
92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;
93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;
94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;
95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;

Line 92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;

88: c_availability_time fv_sf133_definitions_accts.availability_time%TYPE;
89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;
90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;
91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;
92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;
93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;
94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;
95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;
96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;

Line 93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;

89: c_bea_category_code fv_sf133_definitions_accts.bea_category_code%TYPE;
90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;
91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;
92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;
93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;
94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;
95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;
96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;
97: c_expiration_flag fv_sf133_definitions_accts.expiration_flag%TYPE;

Line 94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;

90: c_borrowing_source_code fv_sf133_definitions_accts.borrowing_source_code%TYPE;
91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;
92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;
93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;
94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;
95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;
96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;
97: c_expiration_flag fv_sf133_definitions_accts.expiration_flag%TYPE;
98: c_fund_type fv_sf133_definitions_accts.fund_type%TYPE;

Line 95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;

91: c_transaction_partner fv_sf133_definitions_accts.transaction_partner%TYPE;
92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;
93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;
94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;
95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;
96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;
97: c_expiration_flag fv_sf133_definitions_accts.expiration_flag%TYPE;
98: c_fund_type fv_sf133_definitions_accts.fund_type%TYPE;
99: c_financing_account_code fv_sf133_definitions_accts.financing_account_code%TYPE;

Line 96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;

92: c_year_of_budget_authority fv_sf133_definitions_accts.year_of_budget_authority%TYPE;
93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;
94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;
95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;
96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;
97: c_expiration_flag fv_sf133_definitions_accts.expiration_flag%TYPE;
98: c_fund_type fv_sf133_definitions_accts.fund_type%TYPE;
99: c_financing_account_code fv_sf133_definitions_accts.financing_account_code%TYPE;
100:

Line 97: c_expiration_flag fv_sf133_definitions_accts.expiration_flag%TYPE;

93: c_prior_year_adjustment fv_sf133_definitions_accts.prior_year_adjustment%TYPE;
94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;
95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;
96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;
97: c_expiration_flag fv_sf133_definitions_accts.expiration_flag%TYPE;
98: c_fund_type fv_sf133_definitions_accts.fund_type%TYPE;
99: c_financing_account_code fv_sf133_definitions_accts.financing_account_code%TYPE;
100:
101: exp_date date;

Line 98: c_fund_type fv_sf133_definitions_accts.fund_type%TYPE;

94: c_authority_type fv_sf133_definitions_accts.authority_type%TYPE;
95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;
96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;
97: c_expiration_flag fv_sf133_definitions_accts.expiration_flag%TYPE;
98: c_fund_type fv_sf133_definitions_accts.fund_type%TYPE;
99: c_financing_account_code fv_sf133_definitions_accts.financing_account_code%TYPE;
100:
101: exp_date date;
102: beg_date date;

Line 99: c_financing_account_code fv_sf133_definitions_accts.financing_account_code%TYPE;

95: c_tafs_status fv_sf133_definitions_accts.tafs_status%TYPE;
96: c_availability_type fv_sf133_definitions_accts.availability_type%TYPE;
97: c_expiration_flag fv_sf133_definitions_accts.expiration_flag%TYPE;
98: c_fund_type fv_sf133_definitions_accts.fund_type%TYPE;
99: c_financing_account_code fv_sf133_definitions_accts.financing_account_code%TYPE;
100:
101: exp_date date;
102: beg_date date;
103: close_date date;

Line 149: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;

145:
146: c_sf133_report_line_number fv_sf133_definitions_lines.sf133_report_line_number%TYPE;
147: --
148: -- ---------- Balance Type Cursor Vaiables ---------
149: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
150: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
151:
152: -- new variables declared by Narsimha.
153:

Line 150: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;

146: c_sf133_report_line_number fv_sf133_definitions_lines.sf133_report_line_number%TYPE;
147: --
148: -- ---------- Balance Type Cursor Vaiables ---------
149: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
150: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
151:
152: -- new variables declared by Narsimha.
153:
154: -- c_sf133_apportion_amt number;

Line 155: c_sf133_additional_info fv_sf133_definitions_accts.sf133_additional_info%TYPE;

151:
152: -- new variables declared by Narsimha.
153:
154: -- c_sf133_apportion_amt number;
155: c_sf133_additional_info fv_sf133_definitions_accts.sf133_additional_info%TYPE;
156:
157: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
158: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
159: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

Line 270: FROM fv_sf133_definitions_accts

266: availability_type,
267: expiration_flag,
268: fund_type,
269: financing_account_code
270: FROM fv_sf133_definitions_accts
271: WHERE sf133_line_id = c_sf133_line_id ;
272:
273: PROCEDURE determine_acct_flex_segments;
274: PROCEDURE purge_temp_table;

Line 612: fv_sf133_definitions_accts acct,

608: ROUND(NVL(SUM((NVL(glbal.period_net_dr,0)-NVL(glbal.period_net_cr,0))
609: +
610: (NVL(glbal.begin_balance_dr,0)-NVL(glbal.begin_balance_cr,0))),0),2))) ' || '
611: FROM gl_balances glbal,
612: fv_sf133_definitions_accts acct,
613: fv_sf133_ccids_gt fscg
614: WHERE glbal.ledger_id = :cv_set_of_books_id
615: AND glbal.period_year = :cv_fiscal_year
616: AND glbal.period_num = :cv_period

Line 1294: query_fetch_bal := 'select sum(nvl(amount,0)) from fv_facts_temp fac, fv_sf133_definitions_accts acct

1290: if( c_sf133_balance_type = 'B' OR c_sf133_balance_type = 'E') then
1291:
1292: if(( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='D')
1293: or ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='C'))then
1294: query_fetch_bal := 'select sum(nvl(amount,0)) from fv_facts_temp fac, fv_sf133_definitions_accts acct
1295: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1296: AND acct.sf133_line_id = :cv_sf133_line_id
1297: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1298: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1304: query_fetch_bal := 'select sum(nvl(amount,0)*(-1)) from fv_facts_temp fac, fv_sf133_definitions_accts acct

1300: AND begin_end = '''||c_sf133_balance_type||'''';
1301:
1302: elsif (( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='C') or
1303: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D') ) then
1304: query_fetch_bal := 'select sum(nvl(amount,0)*(-1)) from fv_facts_temp fac, fv_sf133_definitions_accts acct
1305: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1306: AND acct.sf133_line_id = :cv_sf133_line_id
1307: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1308: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1354: from fv_facts_temp fac, fv_sf133_definitions_accts acct

1350: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='C') ) then
1351:
1352: query_fetch_bal := ' select
1353: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) )
1354: from fv_facts_temp fac, fv_sf133_definitions_accts acct
1355: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1356: AND acct.sf133_line_id = :cv_sf133_line_id
1357: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1358: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1394: from fv_facts_temp fac, fv_sf133_definitions_accts acct

1390: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D'))then
1391:
1392: query_fetch_bal := ' select
1393: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) )*(-1)
1394: from fv_facts_temp fac, fv_sf133_definitions_accts acct
1395: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1396: AND acct.sf133_line_id = :cv_sf133_line_id
1397: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1398: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1431: query_fetch_bal := 'select sum(nvl(amount,0)) from fv_facts_temp fac, fv_sf133_definitions_accts acct

1427: END IF;
1428:
1429: elsif (( c_sf133_balance_type= 'ED') or( c_sf133_balance_type= 'EC')) then -- bal type is ending debit or ending credit only
1430:
1431: query_fetch_bal := 'select sum(nvl(amount,0)) from fv_facts_temp fac, fv_sf133_definitions_accts acct
1432: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1433: AND acct.sf133_line_id = :cv_sf133_line_id
1434: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1435: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1493: from fv_facts_temp fac, fv_sf133_definitions_accts acct

1489: elsif( (c_sf133_balance_type= 'E-BD') or (c_sf133_balance_type='E-BC')) then -- bal type is end begin debit only
1490:
1491: query_fetch_bal := ' select
1492: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) )
1493: from fv_facts_temp fac, fv_sf133_definitions_accts acct
1494: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1495: AND acct.sf133_line_id = :cv_sf133_line_id
1496: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1497: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1956: FROM fv_sf133_definitions_accts fsda,

1952: fsda.segment27,
1953: fsda.segment28,
1954: fsda.segment29,
1955: fsda.segment30
1956: FROM fv_sf133_definitions_accts fsda,
1957: fv_sf133_definitions_lines fsdl
1958: WHERE fsdl.sf133_line_id = fsda.sf133_line_id
1959: AND fsdl.set_of_books_id=p_sobid
1960: ORDER BY 2,1;

Line 2190: fv_facts_temp facE, fv_sf133_definitions_accts acct

2186: BEGIN
2187: -- get the bal indicator of all E records if there are records of multiple bal types
2188: query_Ending_Indicator := 'select sum(decode(facE.debit_credit,''D'',amount)),
2189: sum(decode(facE.debit_credit,''C'',amount)) from
2190: fv_facts_temp facE, fv_sf133_definitions_accts acct
2191: where facE.treasury_symbol_id = '||g_treasury_symbol_id||
2192: 'AND acct.sf133_line_id = '||c_sf133_line_id||
2193: 'AND acct.sf133_line_acct_id = '||c_sf133_line_acct_id||
2194: 'and acct_number like facE.sgl_acct_number||''%'' and facE.sgl_acct_number is not null

Line 2219: fv_facts_temp facB, fv_sf133_definitions_accts acct

2215:
2216: -- get the bal indicator of all E records if there are records of multiple bal types
2217: query_Beg_Indicator:= 'select sum(decode(facB.debit_credit,''D'',amount)) ,
2218: sum(decode(facB.debit_credit,''C'',amount)) from
2219: fv_facts_temp facB, fv_sf133_definitions_accts acct
2220: where facB.treasury_symbol_id = '||g_treasury_symbol_id||
2221: 'AND acct.sf133_line_id = '||c_sf133_line_id||
2222: 'AND acct.sf133_line_acct_id = '||c_sf133_line_acct_id||
2223: 'and acct_number like facB.sgl_acct_number||''%'' and facB.sgl_acct_number is not null