DBA Data[Home] [Help]

APPS.FV_AP_CASH_POS_DTL_PKG dependencies on GL_BALANCES

Line 339: /********** and caluculates the gl balances for the funds. **********/

335: /********** **********/
336: /********** PROCEDURE: Create_Cash_Position_Record **********/
337: /********** **********/
338: /********** This procedure pulls all the invoice distributions **********/
339: /********** and caluculates the gl balances for the funds. **********/
340: /********** **********/
341:
342: PROCEDURE Create_Cash_Position_Record IS
343:

Line 398: l_period_num gl_balances.period_num%TYPE;

394:
395: vcheck_rec invoice_cursor%ROWTYPE;
396: l_acct_dist_tbl Fnd_Flex_Ext.segmentarray ;
397: l_get_segments_flag BOOLEAN;
398: l_period_num gl_balances.period_num%TYPE;
399: l_currency_code gl_balances.currency_code%TYPE;
400: l_period_year gl_balances.period_year%TYPE ;
401: l_boolean BOOLEAN;
402: l_num_segments NUMBER;

Line 399: l_currency_code gl_balances.currency_code%TYPE;

395: vcheck_rec invoice_cursor%ROWTYPE;
396: l_acct_dist_tbl Fnd_Flex_Ext.segmentarray ;
397: l_get_segments_flag BOOLEAN;
398: l_period_num gl_balances.period_num%TYPE;
399: l_currency_code gl_balances.currency_code%TYPE;
400: l_period_year gl_balances.period_year%TYPE ;
401: l_boolean BOOLEAN;
402: l_num_segments NUMBER;
403: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;

Line 400: l_period_year gl_balances.period_year%TYPE ;

396: l_acct_dist_tbl Fnd_Flex_Ext.segmentarray ;
397: l_get_segments_flag BOOLEAN;
398: l_period_num gl_balances.period_num%TYPE;
399: l_currency_code gl_balances.currency_code%TYPE;
400: l_period_year gl_balances.period_year%TYPE ;
401: l_boolean BOOLEAN;
402: l_num_segments NUMBER;
403: l_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
404: l_gl_cash_balance NUMBER;

Line 473: ' FROM GL_BALANCES GLB,' ||

469:
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) ||''''||