APPS.FV_FACTS2_DERIVE_BALANCES dependencies on GL_BALANCES

Line 749: --* : gl_balances glbal SELECT *--

745: --* : gl_je_lines gll SELECT *--
746: --* : gl_je_headers gjh SELECT *--
747: --* : gl_period_statuses gps SELECT *--
748: --* : fv_be_trx_dtls SELECT *--
749: --* : gl_balances glbal SELECT *--
750: --* : gl_code_combinations gcc SELECT *--
751: --* : fv_factsii_accounts_gt SELECT *--
752: --* Logic : 1.
753: --****************************************************************************************--

Line 774: l_code_combination_id gl_balances.code_combination_id%TYPE;

770: l_module_name VARCHAR2(200);
771: l_location VARCHAR2(200);
772: TYPE balances_cur_type IS REF CURSOR;
773: balances_cur balances_cur_type;
774: l_code_combination_id gl_balances.code_combination_id%TYPE;
775: l_ending_balance_dr NUMBER;
776: l_ending_balance_cr NUMBER;
777: l_period_num gl_balances.period_num%TYPE;
778: l_account VARCHAR2(30);

Line 777: l_period_num gl_balances.period_num%TYPE;

773: balances_cur balances_cur_type;
774: l_code_combination_id gl_balances.code_combination_id%TYPE;
775: l_ending_balance_dr NUMBER;
776: l_ending_balance_cr NUMBER;
777: l_period_num gl_balances.period_num%TYPE;
778: l_account VARCHAR2(30);
779: l_fund VARCHAR2(30);
780: l_fyr VARCHAR2(30);
781: l_ussgl_account VARCHAR2(30);

Line 1023: FROM gl_balances glbal,

1019: gcc.segment28,
1020: gcc.segment29,
1021: gcc.segment30,'||
1022: 'gcc.'||p_bal_segment||'
1023: FROM gl_balances glbal,
1024: gl_code_combinations gcc,
1025: fv_factsii_accounts_gt fa
1026: WHERE glbal.ledger_id = :b_set_of_books_id
1027: AND glbal.period_year = :b_period_year

Line 1491: l_last_period_num gl_balances.period_num%TYPE;

1487: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;
1488: l_fyr_segment fnd_id_flex_segments.application_column_name%TYPE;
1489: l_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
1490: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
1491: l_last_period_num gl_balances.period_num%TYPE;
1492: l_pub_law_code_col fv_system_parameters.factsii_pub_law_code_attribute%TYPE;
1493: l_advance_type_col fv_system_parameters.factsii_advance_type_attribute%TYPE;
1494: l_tr_main_acct_col fv_system_parameters.factsii_tr_main_acct_attribute%TYPE;
1495: l_tr_dept_id_col fv_system_parameters.factsii_tr_dept_id_attribute%TYPE;