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

Line 79: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;

75: c_sf133_report_line_number fv_sf133_definitions_lines.
76: sf133_report_line_number%TYPE;
77:
78: -- ---------- Balance Type Cursor Vaiables ---------
79: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
80: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
81:
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;

Line 80: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;

76: sf133_report_line_number%TYPE;
77:
78: -- ---------- Balance Type Cursor Vaiables ---------
79: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
80: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
81:
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;

Line 82: c_acct_number fv_sf133_definitions_accts.acct_number%TYPE;

78: -- ---------- Balance Type Cursor Vaiables ---------
79: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
80: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
81:
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: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
80: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
81:
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_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
81:
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:
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 115: c_sf133_additional_info fv_sf133_definitions_accts

111:
112: -- New variables declared by Narsimha.
113:
114: c_sf133_apportion_amt number;
115: c_sf133_additional_info fv_sf133_definitions_accts
116: .sf133_additional_info%TYPE;
117:
118: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
119: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

Line 203: FROM fv_sf133_definitions_accts

199: availability_type,
200: expiration_flag,
201: fund_type,
202: financing_account_code
203: FROM fv_sf133_definitions_accts
204: WHERE sf133_line_id = c_sf133_line_id ;
205:
206: --Cursor to find all the Treasury symbols in the input range.
207: --Added a s part of Enh #2129123

Line 518: fv_sf133_definitions_accts acct,

514: ROUND(NVL(SUM((NVL(glbal.period_net_dr,0)-NVL(glbal.period_net_cr,0))
515: + (NVL(glbal.begin_balance_dr,0)-NVL(glbal.begin_balance_cr,0))),0),2))) '|| '
516: FROM gl_balances glbal,
517: gl_code_combinations glcc,
518: fv_sf133_definitions_accts acct,
519: fv_sf133_ccids_gt fscg,
520: fv_fund_parameters FFP
521: WHERE glbal.ledger_id = :cv_sob_id
522: AND glbal.period_year = :cv_period_year

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

535: AND FFP.set_of_books_id = :cv_sob_id
536: AND fund_category like nvl(:cv_sf133_line_category, ' || '''' ||'%' || ''''||')';*/
537:
538:
539: v_select:= 'select sum(nvl(amount,0)) from fv_facts_temp fac, fv_sf133_definitions_accts acct
540: where fac.treasury_symbol_id = :cv_treasury_symbol_id
541: AND acct.sf133_line_id = :cv_sf133_line_id
542: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
543: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

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

1013: if( c_sf133_balance_type = 'B' OR c_sf133_balance_type = 'E') then
1014:
1015: if(( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='D')
1016: or ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='C'))then
1017: query_fetch_bal := 'select sum(nvl(amount,0)) from fv_facts_temp fac, fv_sf133_definitions_accts acct
1018: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1019: AND acct.sf133_line_id = :cv_sf133_line_id
1020: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1021: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

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

1023: AND begin_end = '''||c_sf133_balance_type||'''';
1024:
1025: elsif (( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='C') or
1026: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D') ) then
1027: query_fetch_bal := 'select sum(nvl(amount,0)*(-1)) from fv_facts_temp fac, fv_sf133_definitions_accts acct
1028: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1029: AND acct.sf133_line_id = :cv_sf133_line_id
1030: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1031: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1076: from fv_facts_temp fac, fv_sf133_definitions_accts acct

1072: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='C') ) then
1073:
1074: query_fetch_bal := ' select
1075: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) )
1076: from fv_facts_temp fac, fv_sf133_definitions_accts acct
1077: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1078: AND acct.sf133_line_id = :cv_sf133_line_id
1079: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1080: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1116: from fv_facts_temp fac, fv_sf133_definitions_accts acct

1112: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D'))then
1113:
1114: query_fetch_bal := ' select
1115: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) )*(-1)
1116: from fv_facts_temp fac, fv_sf133_definitions_accts acct
1117: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1118: AND acct.sf133_line_id = :cv_sf133_line_id
1119: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1120: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

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

1149: END IF;
1150:
1151: elsif (( c_sf133_balance_type= 'ED') or( c_sf133_balance_type= 'EC')) then -- bal type is ending debit or ending credit only
1152:
1153: query_fetch_bal := 'select sum(nvl(amount,0)) from fv_facts_temp fac, fv_sf133_definitions_accts acct
1154: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1155: AND acct.sf133_line_id = :cv_sf133_line_id
1156: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1157: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1215: from fv_facts_temp fac, fv_sf133_definitions_accts acct

1211: elsif( (c_sf133_balance_type= 'E-BD') or (c_sf133_balance_type='E-BC')) then -- bal type is end begin debit only
1212:
1213: query_fetch_bal := ' select
1214: SUM(DECODE (begin_end,''E'',nvl(AMOUNT,0),''B'',nvl(AMOUNT,0)*(-1)) )
1215: from fv_facts_temp fac, fv_sf133_definitions_accts acct
1216: where fac.treasury_symbol_id = :cv_treasury_symbol_id
1217: AND acct.sf133_line_id = :cv_sf133_line_id
1218: AND acct.sf133_line_acct_id = :cv_sf133_line_acct_id
1219: and acct_number like fac.sgl_acct_number||''%'' and fac.sgl_acct_number is not null

Line 1563: FROM fv_sf133_definitions_accts fsda,

1559: fsda.segment27,
1560: fsda.segment28,
1561: fsda.segment29,
1562: fsda.segment30
1563: FROM fv_sf133_definitions_accts fsda,
1564: fv_sf133_definitions_lines fsdl
1565: WHERE fsdl.sf133_line_id = fsda.sf133_line_id
1566: AND fsdl.set_of_books_id=p_sobid
1567:

Line 1805: fv_facts_temp facE, fv_sf133_definitions_accts acct

1801: BEGIN
1802: -- get the bal indicator of all E records if there are records of multiple bal types
1803: query_Ending_Indicator := 'select sum(decode(facE.debit_credit,''D'',amount)),
1804: sum(decode(facE.debit_credit,''C'',amount)) from
1805: fv_facts_temp facE, fv_sf133_definitions_accts acct
1806: where facE.treasury_symbol_id = '||parm_tsymbol_id||
1807: 'AND acct.sf133_line_id = '||c_sf133_line_id||
1808: 'AND acct.sf133_line_acct_id = '||c_sf133_line_acct_id||
1809: 'and acct_number like facE.sgl_acct_number||''%'' and facE.sgl_acct_number is not null

Line 1834: fv_facts_temp facB, fv_sf133_definitions_accts acct

1830:
1831: -- get the bal indicator of all E records if there are records of multiple bal types
1832: query_Beg_Indicator:= 'select sum(decode(facB.debit_credit,''D'',amount)) ,
1833: sum(decode(facB.debit_credit,''C'',amount)) from
1834: fv_facts_temp facB, fv_sf133_definitions_accts acct
1835: where facB.treasury_symbol_id = '||parm_tsymbol_id||
1836: 'AND acct.sf133_line_id = '||c_sf133_line_id||
1837: 'AND acct.sf133_line_acct_id = '||c_sf133_line_acct_id||
1838: 'and acct_number like facB.sgl_acct_number||''%'' and facB.sgl_acct_number is not null