APPS.FV_FACTS_TRANSACTIONS dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 109: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;

105: v_fiscal_yr VARCHAR2(25);
106: v_dummy_cohort VARCHAR2(25);
107: v_acct_attr_flag VARCHAR2(1) ;
108: v_record_category fv_facts_temp.fct_int_record_category%TYPE ;
109: v_sgl_acct_num fv_facts_ussgl_accounts.ussgl_account%TYPE ;
110: v_amount NUMBER ;
111: v_year_budget_auth VARCHAR2(3);
112: v_tbal_fund_value fv_fund_parameters.fund_value%TYPE ;
113: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;

Line 1592: FROM fv_facts_ussgl_accounts

1588: v_year_budget_auth := ' ';
1589: BEGIN
1590: SELECT disbursements_flag
1591: INTO vl_disbursements_flag
1592: FROM fv_facts_ussgl_accounts
1593: WHERE ussgl_account = vl_sgl_acct_num;
1594:
1595: -- CGAC: Use Authority Duration Code values of A Annual account, M Multiyear account ,
1596: -- X No-year account. Remove references to REVOLVING

Line 3482: FROM fv_facts_ussgl_accounts

3478: AND flex_value_set_id = v_acc_val_set_id
3479: AND parent_flex_value <> 'T'
3480: AND parent_flex_value in
3481: (SELECT ussgl_account
3482: FROM fv_facts_ussgl_accounts
3483: WHERE ussgl_account = parent_flex_value) ;
3484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3486: 'Parent in GL - ' || vl_ussgl_acct_num) ;

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

3554: END IF ;
3555: END ;
3556: END IF ;
3557: ELSE
3558: -- Parent not exist in FV_FACTS_USSGL_ACCOUNTS table.
3559: get_account_type(vl_ussgl_acct_num, vl_acct_type) ;
3560: IF vp_retcode <> 0 THEN
3561: RETURN ;
3562: END IF ;

Line 4163: FROM fv_facts_ussgl_accounts

4159: SELECT ussgl_enabled_flag,
4160: reporting_type
4161: INTO enabled_flag,
4162: reporting_type
4163: FROM fv_facts_ussgl_accounts
4164: WHERE ussgl_account = ussgl_acct_num ;
4165: EXCEPTION
4166: WHEN NO_DATA_FOUND Then
4167: -- Account Number not found in FV_FACTS_USSGL_ACCOUNTS table.

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

4163: FROM fv_facts_ussgl_accounts
4164: WHERE ussgl_account = ussgl_acct_num ;
4165: EXCEPTION
4166: WHEN NO_DATA_FOUND Then
4167: -- Account Number not found in FV_FACTS_USSGL_ACCOUNTS table.
4168: -- Return Nulls.
4169: enabled_flag := NULL ;
4170: reporting_type := NULL ;
4171: WHEN OTHERS THEN

Line 4238: FROM fv_facts_ussgl_accounts

4234: AND flex_value_set_id = v_acc_val_set_id
4235: AND parent_flex_value <> 'T'
4236: AND parent_flex_value IN
4237: (SELECT ussgl_account
4238: FROM fv_facts_ussgl_accounts
4239: WHERE ussgl_account = parent_flex_value) ;
4240: BEGIN
4241: -- Look for parent in FV_FACTS_ATTRIBUTES table
4242: SELECT 'X'