DBA Data[Home] [Help]

APPS.FV_SF133_NOYEAR dependencies on GL_CODE_COMBINATIONS

Line 63: c_sf133_ts_value gl_code_combinations.segment1%TYPE;

59: v_balance_column_name fnd_id_flex_segments.application_column_name%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;

Line 411: gl_code_combinations glcc,

407: + (NVL(glbal.begin_balance_dr,0)-NVL(glbal.begin_balance_cr,0))),0),2)),1,0,
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

Line 1275: FROM gl_code_combinations gcc,

1271: ccid
1272: )
1273: SELECT :b_sf133_line_acct_id,
1274: gcc.code_combination_id
1275: FROM gl_code_combinations gcc,
1276: fv_fund_parameters FFP
1277: WHERE gcc.' || v_balance_column_name ||' = ffp.fund_value
1278: AND ffp.treasury_symbol_id = :b_treasury_symbol_id
1279: AND ffp.set_of_books_id = :b_set_of_books_id