APPS.FV_AP_CASH_POS_DTL_PKG dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 181: FROM fv_facts_ussgl_accounts

177: AND segment_num = p_acct_segment_num ;
178:
179: CURSOR cash_position_accounts_cur IS
180: SELECT ussgl_account
181: FROM fv_facts_ussgl_accounts
182: WHERE cash_position_flag = 'Y'
183: AND ussgl_enabled_flag = 'Y';
184:
185: CURSOR parent_child_rollups_cur(p_acct VARCHAR2,p_value_set_id NUMBER) IS

Line 222: l_cash_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;

218: FROM ap_system_parameters;
219:
220: l_record_count NUMBER;
221: l_count NUMBER;
222: l_cash_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
223: l_parent_rollups VARCHAR2(1);
224:
225: BEGIN
226: l_module_name := g_module_name || 'Initialize_Process';

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 405: l_cash_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%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) ;
408: l_exec_ret INTEGER ;
409: l_tot_cash_balance NUMBER;