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_TREASURY_SYMBOLS

Line 52: c_resource_type fv_treasury_symbols.resource_type%TYPE;

48: c_end_period VARCHAR2(40);
49:
50: -- New Variables declared by Narsimha Balakkari.
51:
52: c_resource_type fv_treasury_symbols.resource_type%TYPE;
53: c_rescission_flag Varchar2(10);
54:
55: -- ---------- Flex Segment Name Cursor Variables ---------
56: c_segment_name fnd_id_flex_segments.segment_name%TYPE;

Line 72: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;
69: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;
70:
71: -- New variable declared by pkpatel to fix Bug 1575992
72: c_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
73: --
74: -- New variable declared by Narsimha.
75: c_sf133_report_line_number fv_sf133_definitions_lines.
76: sf133_report_line_number%TYPE;

Line 130: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

126: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
127: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
128:
129: -- New variable declared by pkpatel to fix Bug 1575992
130: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
131:
132: --New variables
133: v_select VARCHAR2(8600);
134: v_cursor_id INTEGER;

Line 172: FV_TREASURY_SYMBOLS FTS

168: line.sf133_natural_balance_type sf133_natural_balance_type,
169: line.sf133_fund_category sf133_line_category,
170: line.sf133_report_line_number sf133_report_line_number
171: FROM fv_sf133_definitions_lines line,
172: FV_TREASURY_SYMBOLS FTS
173: WHERE FTS.SET_OF_BOOKS_ID = LINE.SET_OF_BOOKS_ID
174: AND FTS.Treasury_symbol = parm_treasury_value_r1
175: AND FTS.set_of_books_id = parm_set_of_books_id
176: AND (line.sf133_line_type_code) IN ('T', 'D', 'D2')

Line 211: FROM fv_treasury_symbols

207: --Added a s part of Enh #2129123
208: --
209: CURSOR ts_range_cursor(tsymbol_r1 VARCHAR2, tsymbol_r2 VARCHAR2) IS
210: SELECT treasury_symbol, treasury_symbol_id
211: FROM fv_treasury_symbols
212: WHERE TIME_FRAME IN ('X','M')--CGAC
213: AND (FUND_GROUP_CODE NOT BETWEEN '3800' AND '3899')
214: AND (FUND_GROUP_CODE NOT BETWEEN '6001' AND '6999')
215: AND treasury_symbol BETWEEN tsymbol_r1 AND tsymbol_r2

Line 788: financing_account_treas fv_treasury_symbols.financing_account%TYPE;

784: query_fetch_bal VARCHAR2(8600);
785: where_clause VARCHAR2(8600);
786:
787: --CGAC
788: financing_account_treas fv_treasury_symbols.financing_account%TYPE;
789: availability_type_treas fv_treasury_symbols.availability_type_code%TYPE;
790: fund_type_treas fv_treasury_symbols.fund_type%TYPE;
791: BEGIN
792: l_module_name := g_module_name || 'build_fiscal_line_columns';

Line 789: availability_type_treas fv_treasury_symbols.availability_type_code%TYPE;

785: where_clause VARCHAR2(8600);
786:
787: --CGAC
788: financing_account_treas fv_treasury_symbols.financing_account%TYPE;
789: availability_type_treas fv_treasury_symbols.availability_type_code%TYPE;
790: fund_type_treas fv_treasury_symbols.fund_type%TYPE;
791: BEGIN
792: l_module_name := g_module_name || 'build_fiscal_line_columns';
793:

Line 790: fund_type_treas fv_treasury_symbols.fund_type%TYPE;

786:
787: --CGAC
788: financing_account_treas fv_treasury_symbols.financing_account%TYPE;
789: availability_type_treas fv_treasury_symbols.availability_type_code%TYPE;
790: fund_type_treas fv_treasury_symbols.fund_type%TYPE;
791: BEGIN
792: l_module_name := g_module_name || 'build_fiscal_line_columns';
793:
794: --

Line 849: from fv_treasury_symbols

845:
846: c_rescission_flag := 'FALSE';
847: IF upper(c_sf133_additional_info) = 'RESCISSION' THEN
848: select upper(resource_type) into c_resource_type
849: from fv_treasury_symbols
850: where treasury_symbol = parm_treasury_value_r1
851: and set_of_books_id = parm_set_of_books_id;
852: IF c_resource_type like '%APPROPRIATION%' THEN
853: IF ltrim(rtrim(c_sf133_report_line_number)) = '1A' THEN

Line 889: FROM fv_treasury_symbols

885:
886: --CGAC
887: SELECT availability_type_code, fund_type, expiration_Date
888: INTO availability_type_treas, fund_type_treas, exp_date
889: FROM fv_treasury_symbols
890: WHERE treasury_symbol_id=parm_tsymbol_id
891: AND set_of_books_id = parm_set_of_books_id;
892:
893: -- Extract expiration date of treasury symbol and determine if the TS expired

Line 908: select extract ( year from expiration_date)into expiring_year from fv_treasury_symbols where treasury_symbol_id=parm_tsymbol_id;

904: whether_Exp_SameYear := 'N';
905: end if;
906:
907: IF (exp_date is not null) then
908: select extract ( year from expiration_date)into expiring_year from fv_treasury_symbols where treasury_symbol_id=parm_tsymbol_id;
909: if (expiring_year is not null and expiring_year = parm_gl_period_year) then
910: whether_Exp_SameYear := 'Y';
911: elsif ( expiring_year > parm_gl_period_year) then
912: whether_Exp_SameYear := 'N';

Line 919: FROM fv_treasury_symbols

915:
916: --CGAC
917: SELECT financing_account
918: INTO financing_account_treas
919: FROM fv_treasury_symbols
920: WHERE treasury_symbol_id = parm_tsymbol_id
921: AND set_of_books_id = parm_set_of_books_id;
922:
923: