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 719: FROM gl_code_combinations gcc,gl_balances gb

715: BEGIN
716: FOR I IN parent_child_rollups_cur(gbl_flex_value_set_id)
717: LOOP
718: v_query := 'SELECT NVL(SUM((period_net_dr + begin_balance_dr) - (period_net_cr + begin_balance_cr)),0)
719: FROM gl_code_combinations gcc,gl_balances gb
720: WHERE gb.code_combination_id = gcc.code_combination_id
721: AND gcc.chart_of_accounts_id =' || gbl_account_id ||
722: 'AND (GB.PERIOD_NUM,GB.PERIOD_YEAR) IN (SELECT MAX(PERIOD_NUM),PERIOD_YEAR
723: FROM gl_period_statuses

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

761: AND closing_status <> 'F'
762: AND closing_status <> 'N'
763: AND adjustment_period_flag = 'N'
764: AND ledger_id = gbl_set_of_books_id;
765: v_query := 'SELECT count(1) FROM gl_je_lines gjl,gl_code_combinations gcc
766: WHERE gjl.ledger_id =' || gbl_set_of_books_id ||
767: 'AND gjl.code_combination_id = gcc.code_combination_id
768: AND gcc.chart_of_accounts_id ='|| gbl_account_id ||
769: 'AND gcc.'||gbl_bal_segment_name ||' = :p