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.FVFCCHKB_PKG dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 105: -- FV_FACTS_USSGL_ACCOUNTS for all budgetary accounts

101:
102: PROCEDURE edit_check_2 IS
103:
104: -- Cursor to fetch SGL account and associated attributes from
105: -- FV_FACTS_USSGL_ACCOUNTS for all budgetary accounts
106: -- existing in FV_FACTS_TEMP
107: CURSOR fv_facts_ussgl_accounts_c IS
108: SELECT ffa.ussgl_account,
109: ffa.total_resource_be_flag, ffa.total_resource_dc_flag,

Line 107: CURSOR fv_facts_ussgl_accounts_c IS

103:
104: -- Cursor to fetch SGL account and associated attributes from
105: -- FV_FACTS_USSGL_ACCOUNTS for all budgetary accounts
106: -- existing in FV_FACTS_TEMP
107: CURSOR fv_facts_ussgl_accounts_c IS
108: SELECT ffa.ussgl_account,
109: ffa.total_resource_be_flag, ffa.total_resource_dc_flag,
110: ffa.resource_status_be_flag, ffa.resource_status_dc_flag
111: FROM fv_facts_ussgl_accounts ffa

Line 111: FROM fv_facts_ussgl_accounts ffa

107: CURSOR fv_facts_ussgl_accounts_c IS
108: SELECT ffa.ussgl_account,
109: ffa.total_resource_be_flag, ffa.total_resource_dc_flag,
110: ffa.resource_status_be_flag, ffa.resource_status_dc_flag
111: FROM fv_facts_ussgl_accounts ffa
112: WHERE ffa.ussgl_account like '4%'
113: AND EXISTS
114: (SELECT 'x'
115: FROM fv_facts_temp fft

Line 140: OPEN fv_facts_ussgl_accounts_c;

136: BEGIN
137: init_vars;
138: v_edit_check_number := 2;
139:
140: OPEN fv_facts_ussgl_accounts_c;
141:
142: LOOP
143:
144: FETCH fv_facts_ussgl_accounts_c

Line 144: FETCH fv_facts_ussgl_accounts_c

140: OPEN fv_facts_ussgl_accounts_c;
141:
142: LOOP
143:
144: FETCH fv_facts_ussgl_accounts_c
145: INTO l_ussgl_account,
146: l_total_resource_be_flag,
147: l_total_resource_dc_flag,
148: l_resource_status_be_flag,

Line 151: EXIT WHEN fv_facts_ussgl_accounts_c%NOTFOUND

147: l_total_resource_dc_flag,
148: l_resource_status_be_flag,
149: l_resource_status_dc_flag;
150:
151: EXIT WHEN fv_facts_ussgl_accounts_c%NOTFOUND
152: OR fv_facts_ussgl_accounts_c%NOTFOUND IS NULL;
153:
154: -- Fetch beginning balance and set debit_credit
155: -- indicator for the SGL account

Line 152: OR fv_facts_ussgl_accounts_c%NOTFOUND IS NULL;

148: l_resource_status_be_flag,
149: l_resource_status_dc_flag;
150:
151: EXIT WHEN fv_facts_ussgl_accounts_c%NOTFOUND
152: OR fv_facts_ussgl_accounts_c%NOTFOUND IS NULL;
153:
154: -- Fetch beginning balance and set debit_credit
155: -- indicator for the SGL account
156:

Line 287: CLOSE fv_facts_ussgl_accounts_c;

283: create_log_record(v_log_text);
284:
285: END LOOP;
286:
287: CLOSE fv_facts_ussgl_accounts_c;
288:
289: l_st_total := -1*l_st_total;
290:
291: IF (l_to_total = l_st_total) THEN

Line 376: fv_facts_ussgl_accounts ffa

372: -- where YE_ANTICIPATED_FLAG = 'Y'
373: CURSOR anticipated_items_c is
374: SELECT nvl(sum(fft.amount),0), fft.sgl_acct_number
375: FROM fv_facts_temp fft,
376: fv_facts_ussgl_accounts ffa
377: WHERE treasury_symbol_id = g_treasury_symbol_id
378: AND fct_int_record_category = 'REPORTED_NEW'
379: AND fct_int_record_type = 'BLK_DTL'
380: AND ffa.ussgl_account = fft.sgl_acct_number

Line 446: fv_facts_ussgl_accounts ffa

442: CURSOR check5 IS
443: SELECT fft.sgl_acct_number, nvl(amount,0) amount,
444: ffa.ye_resource_equity_flag
445: FROM fv_facts_temp fft,
446: fv_facts_ussgl_accounts ffa
447: WHERE fft.treasury_symbol_id = g_treasury_symbol_id
448: AND fft.fct_int_record_category = 'REPORTED_NEW'
449: AND fft.fct_int_record_type = 'BLK_DTL'
450: AND ffa.ussgl_account = fft.sgl_acct_number

Line 607: fv_facts_ussgl_accounts ffa

603: -- fund_balance_account_flag is 'Y'
604: CURSOR check7 IS
605: SELECT nvl(fft.amount,0) amount, fft.sgl_acct_number
606: FROM fv_facts_temp fft,
607: fv_facts_ussgl_accounts ffa
608: WHERE ffa.fund_balance_account_flag = 'Y'
609: AND fft.sgl_acct_number = ffa.ussgl_account
610: AND fft.treasury_symbol_id = g_treasury_symbol_id
611: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 677: fv_facts_ussgl_accounts ffacc

673: CURSOR check10 IS
674: SELECT fft.sgl_acct_number,
675: SUM(NVL(fft.amount,0)) amount
676: FROM fv_facts_temp fft,
677: fv_facts_ussgl_accounts ffacc
678: WHERE ffacc.ussgl_account = fft.sgl_acct_number
679: AND fft.treasury_symbol_id = g_treasury_symbol_id
680: AND fft.fct_int_record_category = 'REPORTED_NEW'
681: AND fft.fct_int_record_type = 'BLK_DTL'

Line 726: fv_facts_ussgl_accounts ffacc

722: NVL(sum(fft.amount),0),
723: ffacc.ye_neg_receivables_flag,
724: ffacc.natural_balance
725: FROM fv_facts_temp fft,
726: fv_facts_ussgl_accounts ffacc
727: WHERE (ffacc.ye_neg_receivables_flag = 'Y'
728: OR ffacc.ye_neg_payables_flag = 'Y')
729: AND ffacc.ussgl_account = fft.sgl_acct_number
730: AND fft.treasury_symbol_id = g_treasury_symbol_id

Line 740: fv_facts_ussgl_accounts ffacc

736: CURSOR general_acc_c IS
737: SELECT ffacc.ussgl_account, nvl(sum(fft.amount),0),
738: ffacc.natural_balance
739: FROM fv_facts_temp fft,
740: fv_facts_ussgl_accounts ffacc
741: WHERE ffacc.ye_general_flag = 'Y'
742: AND ffacc.ussgl_account = fft.sgl_acct_number
743: AND fft.treasury_symbol_id = g_treasury_symbol_id
744: AND fft.fct_int_record_category = 'REPORTED_NEW'

Line 754: l_natural_balance FV_FACTS_USSGL_ACCOUNTS.NATURAL_BALANCE%TYPE;

750: l_amount number;
751: l_acc_type varchar2(25);
752: l_count number;
753: l_neg_receivables_flag varchar2(1);
754: l_natural_balance FV_FACTS_USSGL_ACCOUNTS.NATURAL_BALANCE%TYPE;
755: l_dc_ind varchar2(1);
756:
757: BEGIN
758:

Line 912: fv_facts_ussgl_accounts ffa

908: ffa.collections_flag,
909: ffa.edck12_balance_type,
910: nvl(amount,0) amount
911: FROM fv_facts_temp fft,
912: fv_facts_ussgl_accounts ffa
913: WHERE (ffa.disbursements_flag = 'Y' or ffa.collections_flag = 'Y')
914: AND ffa.ussgl_account = fft.sgl_acct_number
915: AND fft.treasury_symbol_id = g_treasury_symbol_id
916: AND fft.fct_int_record_category = 'REPORTED_NEW'