APPS.FV_SF133_NOYEAR dependencies on FV_SF133_DEFINITIONS_LINES

Line 64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;

60: g_seg_value_set_id FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_ID%TYPE;
61:
62: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;
68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;

Line 65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;

61:
62: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%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;

Line 66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;

62: -- ---------- Treasury Symbol Report Line Cursor Vaiables -----------
63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%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:

Line 67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%TYPE;

63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;
64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%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

Line 68: c_sf133_natural_bal_type fv_sf133_definitions_lines.sf133_natural_balance_type%TYPE;

64: c_sf133_line_id fv_sf133_definitions_lines.sf133_line_id%TYPE;
65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%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;

Line 69: c_sf133_line_category fv_sf133_definitions_lines.sf133_fund_category%TYPE;

65: c_sf133_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
66: c_sf133_prev_line_number fv_sf133_definitions_lines.sf133_line_number%TYPE;
67: c_sf133_line_type_code fv_sf133_definitions_lines.sf133_line_type_code%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: --

Line 75: c_sf133_report_line_number fv_sf133_definitions_lines.

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;
77:
78: -- ---------- Balance Type Cursor Vaiables ---------
79: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;

Line 135: FROM fv_sf133_definitions_lines line,

131: line.sf133_natural_balance_type sf133_natural_balance_type,
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

Line 546: FROM fv_sf133_definitions_lines

542: FROM fv_sf133_definitions_cols_temp
543: WHERE (sf133_line_id)
544: IN
545: (SELECT sf133_line_id
546: FROM fv_sf133_definitions_lines
547: WHERE set_of_books_id = parm_set_of_books_id);
548: --
549: COMMIT;
550: --

Line 913: FROM fv_sf133_definitions_lines

909: AND sf133_fund_value = c_sf133_ts_value
910: AND (sf133_line_id)
911: IN
912: (SELECT sf133_line_id
913: FROM fv_sf133_definitions_lines
914: WHERE set_of_books_id = parm_set_of_books_id
915: AND sf133_line_number >
916: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
917: AND sf133_line_number < c_sf133_line_number);

Line 1087: fv_sf133_definitions_lines fsdl

1083: fsda.segment28,
1084: fsda.segment29,
1085: fsda.segment30
1086: FROM fv_sf133_definitions_accts fsda,
1087: fv_sf133_definitions_lines fsdl
1088: WHERE fsdl.sf133_line_id = fsda.sf133_line_id
1089: AND fsdl.set_of_books_id=p_sobid
1090:
1091: ORDER BY 2,1;