APPS.FV_SF133_ONEYEAR dependencies on FV_SF133_DEFINITIONS_ACCTS

Line 87: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;

83:
84: c_sf133_report_line_number fv_sf133_definitions_lines.sf133_report_line_number%TYPE;
85: --
86: -- ---------- Balance Type Cursor Vaiables ---------
87: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
88: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
89:
90: -- new variables declared by Narsimha.
91:

Line 88: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;

84: c_sf133_report_line_number fv_sf133_definitions_lines.sf133_report_line_number%TYPE;
85: --
86: -- ---------- Balance Type Cursor Vaiables ---------
87: c_sf133_line_acct_id fv_sf133_definitions_accts.sf133_line_acct_id%TYPE;
88: c_sf133_balance_type fv_sf133_definitions_accts.sf133_balance_type%TYPE;
89:
90: -- new variables declared by Narsimha.
91:
92: -- c_sf133_apportion_amt number;

Line 93: c_sf133_additional_info fv_sf133_definitions_accts.sf133_additional_info%TYPE;

89:
90: -- new variables declared by Narsimha.
91:
92: -- c_sf133_apportion_amt number;
93: c_sf133_additional_info fv_sf133_definitions_accts.sf133_additional_info%TYPE;
94:
95: -- ---------- Treasury Symbol Accummulation Cursor Vaiables ---------
96: c_sf133_column_amount fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
97: c_sf133_amount_not_shown fv_sf133_definitions_cols_temp.sf133_amount_not_shown%TYPE;

Line 171: FROM fv_sf133_definitions_accts

167: IS
168: SELECT sf133_line_acct_id,
169: sf133_balance_type,
170: sf133_additional_info
171: FROM fv_sf133_definitions_accts
172: WHERE sf133_line_id = c_sf133_line_id ;
173:
174: PROCEDURE determine_acct_flex_segments;
175: PROCEDURE purge_temp_table;

Line 441: fv_sf133_definitions_accts acct,

437: ROUND(NVL(SUM((NVL(glbal.period_net_dr,0)-NVL(glbal.period_net_cr,0))
438: +
439: (NVL(glbal.begin_balance_dr,0)-NVL(glbal.begin_balance_cr,0))),0),2))) ' || '
440: FROM gl_balances glbal,
441: fv_sf133_definitions_accts acct,
442: fv_sf133_ccids_gt fscg
443: WHERE glbal.ledger_id = :cv_set_of_books_id
444: AND glbal.period_year = :cv_fiscal_year
445: AND glbal.period_num = :cv_period

Line 1458: FROM fv_sf133_definitions_accts fsda,

1454: fsda.segment27,
1455: fsda.segment28,
1456: fsda.segment29,
1457: fsda.segment30
1458: FROM fv_sf133_definitions_accts fsda,
1459: fv_sf133_definitions_lines fsdl
1460: WHERE fsdl.sf133_line_id = fsda.sf133_line_id
1461: AND fsdl.set_of_books_id=p_sobid
1462: ORDER BY 2,1;