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 100: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;

96: o_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: o_sf133_amt_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;
98:
99: -- New variable declared by pkpatel to fix Bug 1575992
100: o_sf133_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
101:
102: --New variables
103: v_select VARCHAR2(8600);
104: v_cursor_id INTEGER;

Line 136: FV_TREASURY_SYMBOLS FTS

132: line.sf133_fund_category sf133_line_category,
133: line.sf133_report_line_number sf133_report_line_number
134:
135: FROM fv_sf133_definitions_lines line,
136: FV_TREASURY_SYMBOLS FTS
137:
138: WHERE FTS.SET_OF_BOOKS_ID = LINE.SET_OF_BOOKS_ID
139: AND FTS.Treasury_symbol = parm_treasury_value_r1
140: AND FTS.set_of_books_id = parm_set_of_books_id

Line 160: FROM fv_treasury_symbols

156: --Added a s part of Enh #2129123
157: --
158: CURSOR ts_range_cursor(tsymbol_r1 VARCHAR2, tsymbol_r2 VARCHAR2) IS
159: SELECT treasury_symbol, treasury_symbol_id
160: FROM fv_treasury_symbols
161: WHERE TIME_FRAME IN ('NO_YEAR','MULTIPLE','REVOLVING')
162: AND (FUND_GROUP_CODE NOT BETWEEN '3800' AND '3899')
163: AND (FUND_GROUP_CODE NOT BETWEEN '6001' AND '6999')
164: AND treasury_symbol BETWEEN tsymbol_r1 AND tsymbol_r2

Line 728: from fv_treasury_symbols

724:
725: c_rescission_flag := 'FALSE';
726: IF upper(c_sf133_additional_info) = 'RESCISSION' THEN
727: select upper(resource_type) into c_resource_type
728: from fv_treasury_symbols
729: where treasury_symbol = parm_treasury_value_r1
730: and set_of_books_id = parm_set_of_books_id;
731: IF c_resource_type like '%APPROPRIATION%' THEN
732: IF ltrim(rtrim(c_sf133_report_line_number)) = '1A' THEN