APPS.FV_AP_CASH_POS_DTL_PKG dependencies on GL_CODE_COMBINATIONS

Line 14: g_flex_num gl_code_combinations.chart_of_accounts_id%TYPE;

10: g_acct_segment_name VARCHAR2(30);
11: g_check_date DATE;
12: g_set_of_books_id gl_ledgers_public_v.ledger_id %TYPE;
13: g_set_of_books_name gl_ledgers_public_v.name%type;
14: g_flex_num gl_code_combinations.chart_of_accounts_id%TYPE;
15: g_segment_value gl_code_combinations.segment1%TYPE;
16: g_error_code NUMBER(15);
17: g_error_buf VARCHAR2(500);
18: g_error_stage NUMBER(15);

Line 15: g_segment_value gl_code_combinations.segment1%TYPE;

11: g_check_date DATE;
12: g_set_of_books_id gl_ledgers_public_v.ledger_id %TYPE;
13: g_set_of_books_name gl_ledgers_public_v.name%type;
14: g_flex_num gl_code_combinations.chart_of_accounts_id%TYPE;
15: g_segment_value gl_code_combinations.segment1%TYPE;
16: g_error_code NUMBER(15);
17: g_error_buf VARCHAR2(500);
18: g_error_stage NUMBER(15);
19: g_checkrun_name ap_selected_invoices_all.checkrun_name%TYPE;

Line 474: ' GL_CODE_COMBINATIONS GLCC' ||

470: l_bal_select :=
471: 'SELECT SUM((GLB.BEGIN_BALANCE_DR -
472: GLB.BEGIN_BALANCE_CR) + (GLB.PERIOD_NET_DR - PERIOD_NET_CR )) '||
473: ' FROM GL_BALANCES GLB,' ||
474: ' GL_CODE_COMBINATIONS GLCC' ||
475: ' WHERE GLB.code_combination_id = GLCC.code_combination_id ' ||
476: ' AND '||'glb.actual_flag = '|| '''' || 'A' || '''' ||
477: ' AND GLCC.'|| g_bal_segment_name ||' = '||'''' || l_acct_dist_tbl(g_bal_segment_num) ||''''||
478: ' AND ((GLCC.' ||g_acct_segment_name ||' = :l_cash_ussgl_acct ' ||