APPS.FV_FACTS_TRX_REGISTER dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 1690: -- FROM fv_facts_ussgl_accounts

1686: FROM FV_FACTS_ATTRIBUTES
1687: WHERE facts_acct_number = l_account_number
1688: AND set_of_books_id = g_set_of_books_id;
1689: -- AND EXISTS (SELECT 'X'
1690: -- FROM fv_facts_ussgl_accounts
1691: -- WHERE ussgl_account = l_account_number);
1692:
1693: -- Account Number exists in FV_FACTS_ATTRIBUTES table
1694: -- and can be used to get FACTS attributes.

Line 1726: FROM fv_facts_ussgl_accounts

1722: -- Get the USSGL/Parent account
1723: BEGIN
1724: SELECT 'X'
1725: INTO l_exists
1726: FROM fv_facts_ussgl_accounts
1727: WHERE ussgl_account = l_account_number;
1728:
1729: l_sgl_acct_num := l_account_number;
1730: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2911: FROM fv_facts_ussgl_accounts

2907: IF l_sgl_acct_num IS NULL THEN
2908: BEGIN
2909: SELECT 'X'
2910: INTO l_exists
2911: FROM fv_facts_ussgl_accounts
2912: WHERE ussgl_account = l_account_number;
2913: l_sgl_acct_num := l_account_number;
2914: EXCEPTION
2915: WHEN NO_DATA_FOUND THEN

Line 2926: FROM fv_facts_ussgl_accounts

2922:
2923: BEGIN
2924: SELECT disbursements_flag
2925: INTO l_disbursements_flag
2926: FROM fv_facts_ussgl_accounts
2927: WHERE ussgl_account = l_sgl_acct_num;
2928:
2929: EXCEPTION
2930: WHEN OTHERS THEN

Line 4269: FROM fv_facts_ussgl_accounts

4265: SELECT ussgl_enabled_flag,
4266: reporting_type
4267: INTO l_enabled_flag,
4268: l_reporting_type
4269: FROM fv_facts_ussgl_accounts
4270: WHERE ussgl_account = p_ussgl_acct_num;
4271:
4272: p_enabled_flag := l_enabled_flag;
4273: p_reporting_type := l_reporting_type;

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

4272: p_enabled_flag := l_enabled_flag;
4273: p_reporting_type := l_reporting_type;
4274: EXCEPTION
4275: WHEN NO_DATA_FOUND THEN
4276: -- Account Number not found in FV_FACTS_USSGL_ACCOUNTS table.
4277: -- Return Nulls.
4278: p_enabled_flag := NULL;
4279: p_reporting_type := NULL;
4280: WHEN OTHERS THEN

Line 5063: FROM fv_facts_ussgl_accounts

5059: AND parent_flex_value <> 'T'
5060: AND flex_value_set_id = l_acc_val_set_id
5061: AND parent_flex_value IN
5062: (SELECT ussgl_account
5063: FROM fv_facts_ussgl_accounts
5064: WHERE ussgl_account = parent_flex_value);
5065:
5066: BEGIN
5067: -- Look for parent in FV_FACTS_ATTRIBUTES table