APPS.FV_FACTS_TBAL_TRX dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 147: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;

143: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;
144: v_g_edit_check_code number(15);
145: v_acct_attr_flag Varchar2(1) ;
146: */
147: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;
148: v_ccid number;
149: vl_ccid number;
150:
151: v_amount Number ;

Line 2500: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;

2496: vl_disbursements_flag VARCHAR2(1);
2497: /*
2498: * Commented bY 7324248
2499: vl_exists Varchar2(1) ;
2500: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
2501: v_excptn_cat fv_facts_temp.fct_int_record_category%TYPE;
2502: vl_enabled_flag fv_facts_ussgl_accounts.ussgl_enabled_flag%TYPE;
2503: vl_reporting_type fv_facts_ussgl_accounts.reporting_type%TYPE;
2504: */

Line 2502: vl_enabled_flag fv_facts_ussgl_accounts.ussgl_enabled_flag%TYPE;

2498: * Commented bY 7324248
2499: vl_exists Varchar2(1) ;
2500: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
2501: v_excptn_cat fv_facts_temp.fct_int_record_category%TYPE;
2502: vl_enabled_flag fv_facts_ussgl_accounts.ussgl_enabled_flag%TYPE;
2503: vl_reporting_type fv_facts_ussgl_accounts.reporting_type%TYPE;
2504: */
2505: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
2506: vl_parent_sgl_acct_num fv_facts_temp.parent_sgl_acct_number%TYPE;

Line 2503: vl_reporting_type fv_facts_ussgl_accounts.reporting_type%TYPE;

2499: vl_exists Varchar2(1) ;
2500: v_ussgl_acct fv_facts_ussgl_accounts.ussgl_account%TYPE;
2501: v_excptn_cat fv_facts_temp.fct_int_record_category%TYPE;
2502: vl_enabled_flag fv_facts_ussgl_accounts.ussgl_enabled_flag%TYPE;
2503: vl_reporting_type fv_facts_ussgl_accounts.reporting_type%TYPE;
2504: */
2505: vl_fyr_segment_value fv_pya_fiscalyear_map.fyr_segment_value%type;
2506: vl_parent_sgl_acct_num fv_facts_temp.parent_sgl_acct_number%TYPE;
2507: vl_reimb_agree_sel VARCHAR2(250);

Line 2538: FROM fv_facts_ussgl_accounts

2534: End ;
2535:
2536: Begin
2537: SELECT disbursements_flag INTO vl_disbursements_flag
2538: FROM fv_facts_ussgl_accounts
2539: WHERE ussgl_account = v_sgl_acct_num;
2540: exception
2541: when no_data_found then
2542: null;

Line 3036: FROM fv_facts_ussgl_accounts

3032: AND flex_value_set_id = v_acc_val_set_id
3033: AND parent_flex_value <> 'T'
3034: AND parent_flex_value IN
3035: (SELECT ussgl_account
3036: FROM fv_facts_ussgl_accounts
3037: WHERE ussgl_account = parent_flex_value);
3038:
3039: EXCEPTION
3040: WHEN NO_DATA_FOUND THEN

Line 3053: FROM fv_facts_ussgl_accounts

3049: END;
3050:
3051: SELECT ussgl_account
3052: INTO sgl_acct_num
3053: FROM fv_facts_ussgl_accounts
3054: WHERE ussgl_account = acct_num ;
3055:
3056: EXCEPTION
3057: WHEN NO_DATA_FOUND THEN

Line 3061: FROM fv_facts_ussgl_accounts

3057: WHEN NO_DATA_FOUND THEN
3058: BEGIN
3059: SELECT ussgl_account
3060: INTO sgl_acct_num
3061: FROM fv_facts_ussgl_accounts
3062: WHERE ussgl_account = parent_ac ;
3063: EXCEPTION
3064: WHEN NO_DATA_FOUND THEN
3065: sgl_acct_num := NULL ;