APPS.FV_AP_CASH_POS_DTL_PKG dependencies on FND_FLEX_VALUES

Line 31: g_value_set_id fnd_flex_values.flex_value_set_id%TYPE;

27: g_pooled_flag ce_bank_accounts.pooled_flag%TYPE;
28: -- g_bank_acct_name ap_bank_accounts.bank_account_name%TYPE;
29: g_bank_acct_name ce_bank_accounts.bank_account_name%TYPE;
30: --------------------------------------------------------------------*/
31: g_value_set_id fnd_flex_values.flex_value_set_id%TYPE;
32: g_auto_offset_method ap_system_parameters.liability_post_lookup_code%TYPE;
33:
34: /********** ********/
35: /********** PROCEDURE: MAIN ********/

Line 187: FROM fnd_flex_values

183: AND ussgl_enabled_flag = 'Y';
184:
185: CURSOR parent_child_rollups_cur(p_acct VARCHAR2,p_value_set_id NUMBER) IS
186: SELECT 1
187: FROM fnd_flex_values
188: WHERE flex_value_set_id = p_value_set_id
189: AND flex_value = p_acct ;
190: --changed checkrun_name to checkrun_id
191: CURSOR check_date_cur(p_checkrun_id NUMBER) IS

Line 361: FROM fv_facts_ussgl_accounts,fnd_flex_values

357:
358:
359: CURSOR cash_position_acct_cur(p_value_set NUMBER) IS
360: SELECT ussgl_account
361: FROM fv_facts_ussgl_accounts,fnd_flex_values
362: WHERE flex_value_set_id = p_value_set
363: AND flex_value = ussgl_account
364: AND cash_position_flag = 'Y'
365: AND ussgl_enabled_flag = 'Y';

Line 403: l_value_set_id fnd_flex_values.flex_value_set_id%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;
405: l_cash_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
406: l_bal_cursor INTEGER ;
407: l_bal_select VARCHAR2(5000) ;

Line 480: 'FROM fnd_flex_values ffv, fnd_flex_value_hierarchies ffvh '||

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 ' ||
479: ' ) OR GLCC.'||g_acct_segment_name ||' IN (SELECT flex_value '||
480: 'FROM fnd_flex_values ffv, fnd_flex_value_hierarchies ffvh '||
481: 'WHERE ffv.flex_value BETWEEN ffvh.child_flex_value_low
482: AND ffvh.child_flex_value_high
483: AND ffv.flex_value_set_id = :g_value_set_id AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||
484: ' AND parent_flex_value = :l_cash_ussgl_acct)) AND GLB.period_year = :l_period_year AND GLB.period_num = :l_period_num AND GLB.LEDGER_ID = :g_set_of_books_id AND glb.currency_code = :l_currency_code';