APPS.FV_PURGED_TREASURY_SYMBOLS dependencies on GL_CODE_COMBINATIONS

Line 19: gbl_account_id gl_code_combinations.chart_of_accounts_id%type;

15: +-----------------------------*/
16:
17: gbl_error_code Number := 0;
18: gbl_error_buf Varchar2(200);
19: gbl_account_id gl_code_combinations.chart_of_accounts_id%type;
20: gbl_bal_segment_name varchar2(30);
21: gbl_acc_segment_name varchar2(30);
22: gbl_set_of_books_id Gl_ledgers_public_v.ledger_id%TYPE;
23: gbl_last_upd_date DATE;

Line 690: FROM gl_code_combinations gcc,gl_balances gb

686: BEGIN
687: FOR I IN parent_child_rollups_cur(gbl_flex_value_set_id)
688: LOOP
689: v_query := 'SELECT NVL(SUM((period_net_dr + begin_balance_dr) - (period_net_cr + begin_balance_cr)),0)
690: FROM gl_code_combinations gcc,gl_balances gb
691: WHERE gb.code_combination_id = gcc.code_combination_id
692: AND gcc.chart_of_accounts_id =' || gbl_account_id ||
693: 'AND (GB.PERIOD_NUM,GB.PERIOD_YEAR) IN (SELECT MAX(PERIOD_NUM),PERIOD_YEAR
694: FROM gl_period_statuses

Line 736: v_query := 'SELECT count(1) FROM gl_je_lines gjl,gl_code_combinations gcc

732: AND closing_status <> 'F'
733: AND closing_status <> 'N'
734: AND adjustment_period_flag = 'N'
735: AND ledger_id = gbl_set_of_books_id;
736: v_query := 'SELECT count(1) FROM gl_je_lines gjl,gl_code_combinations gcc
737: WHERE gjl.ledger_id =' || gbl_set_of_books_id ||
738: 'AND gjl.code_combination_id = gcc.code_combination_id
739: AND gcc.chart_of_accounts_id ='|| gbl_account_id ||
740: 'AND gcc.'||gbl_bal_segment_name ||' = :p