APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 611: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;

607: vl_seg_app_name VARCHAR2(40) ;
608: vl_seg_prompt VARCHAR2(25) ;
609: vl_seg_value_set_name VARCHAR2(40) ;
610: vl_disbursements_flag VARCHAR2(1);
611: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
612: v_excptn_cat fv_facts_temp.fct_int_record_category%TYPE;
613: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
614: v_fyr_segment_name VARCHAR2(20) ;
615: --v_financing_acct VARCHAR2(1);

Line 1497: FROM fv_facts_ussgl_accounts

1493:
1494:
1495: SELECT disbursements_flag
1496: INTO vl_disbursements_flag
1497: FROM fv_facts_ussgl_accounts
1498: WHERE ussgl_account = v_acct_num;
1499: --ussgl_account = v_ussgl_acct;
1500:
1501: EXCEPTION

Line 2039: From fv_facts_ussgl_accounts

2035: and parent_flex_value <> 'T'
2036: AND flex_value_set_id = vl_acc_val_set_id
2037: and parent_flex_value in
2038: (Select ussgl_account
2039: From fv_facts_ussgl_accounts
2040: Where ussgl_account = parent_flex_value);
2041:
2042: --vp_errbuf := 'SGL Parent Account:'||sgl_acct_num||'-'||acct_num;
2043: --fnd_file.put_line(fnd_file.log, vp_errbuf) ;