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: -- New variables declared by Narsimha.
83:

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: -- New variables declared by Narsimha.
83:
84: c_sf133_apportion_amt number;

Line 85: c_sf133_additional_info fv_sf133_definitions_accts

81:
82: -- New variables declared by Narsimha.
83:
84: c_sf133_apportion_amt number;
85: c_sf133_additional_info fv_sf133_definitions_accts
86: .sf133_additional_info%TYPE;
87:
88: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
89: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;

Line 152: FROM fv_sf133_definitions_accts

148: IS
149: SELECT sf133_line_acct_id,
150: sf133_balance_type,
151: sf133_additional_info
152: FROM fv_sf133_definitions_accts
153: WHERE sf133_line_id = c_sf133_line_id ;
154:
155: --Cursor to find all the Treasury symbols in the input range.
156: --Added a s part of Enh #2129123

Line 412: fv_sf133_definitions_accts acct,

408: ROUND(NVL(SUM((NVL(glbal.period_net_dr,0)-NVL(glbal.period_net_cr,0))
409: + (NVL(glbal.begin_balance_dr,0)-NVL(glbal.begin_balance_cr,0))),0),2))) '|| '
410: FROM gl_balances glbal,
411: gl_code_combinations glcc,
412: fv_sf133_definitions_accts acct,
413: fv_sf133_ccids_gt fscg,
414: fv_fund_parameters FFP
415: WHERE glbal.ledger_id = :cv_sob_id
416: AND glbal.period_year = :cv_period_year

Line 1086: FROM fv_sf133_definitions_accts fsda,

1082: fsda.segment27,
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: