APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 103: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;

99: v_fiscal_yr VARCHAR2(25);
100: v_dummy_cohort VARCHAR2(25);
101: v_acct_attr_flag VARCHAR2(1) ;
102: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
103: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;
104: v_amount NUMBER ;
105: v_year_budget_auth VARCHAR2(3);
106: v_tbal_fund_value fv_fund_parameters.fund_value%TYPE ;
107: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;

Line 1558: FROM fv_facts_ussgl_accounts

1554: v_year_budget_auth := ' ';
1555: BEGIN
1556: SELECT disbursements_flag
1557: INTO vl_disbursements_flag
1558: FROM fv_facts_ussgl_accounts
1559: WHERE ussgl_account = vl_sgl_acct_num;
1560:
1561: IF (v_time_frame = 'NO_YEAR'
1562: AND v_financing_acct = 'N'

Line 3433: FROM fv_facts_ussgl_accounts

3429: AND flex_value_set_id = v_acc_val_set_id
3430: AND parent_flex_value <> 'T'
3431: AND parent_flex_value in
3432: (SELECT ussgl_account
3433: FROM fv_facts_ussgl_accounts
3434: WHERE ussgl_account = parent_flex_value) ;
3435: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3437: 'Parent in GL - ' || vl_ussgl_acct_num) ;

Line 3509: -- Parent not exist in FV_FACTS_USSGL_ACCOUNTS table.

3505: END IF ;
3506: END ;
3507: END IF ;
3508: ELSE
3509: -- Parent not exist in FV_FACTS_USSGL_ACCOUNTS table.
3510: get_account_type(vl_ussgl_acct_num, vl_acct_type) ;
3511: IF vp_retcode <> 0 THEN
3512: RETURN ;
3513: END IF ;

Line 4091: FROM fv_facts_ussgl_accounts

4087: SELECT ussgl_enabled_flag,
4088: reporting_type
4089: INTO enabled_flag,
4090: reporting_type
4091: FROM fv_facts_ussgl_accounts
4092: WHERE ussgl_account = ussgl_acct_num ;
4093: EXCEPTION
4094: WHEN NO_DATA_FOUND Then
4095: -- Account Number not found in FV_FACTS_USSGL_ACCOUNTS table.

Line 4095: -- Account Number not found in FV_FACTS_USSGL_ACCOUNTS table.

4091: FROM fv_facts_ussgl_accounts
4092: WHERE ussgl_account = ussgl_acct_num ;
4093: EXCEPTION
4094: WHEN NO_DATA_FOUND Then
4095: -- Account Number not found in FV_FACTS_USSGL_ACCOUNTS table.
4096: -- Return Nulls.
4097: enabled_flag := NULL ;
4098: reporting_type := NULL ;
4099: WHEN OTHERS THEN

Line 4166: FROM fv_facts_ussgl_accounts

4162: AND flex_value_set_id = v_acc_val_set_id
4163: AND parent_flex_value <> 'T'
4164: AND parent_flex_value IN
4165: (SELECT ussgl_account
4166: FROM fv_facts_ussgl_accounts
4167: WHERE ussgl_account = parent_flex_value) ;
4168: BEGIN
4169: -- Look for parent in FV_FACTS_ATTRIBUTES table
4170: SELECT 'X'