APPS.FV_FACTS_TRX_REGISTER dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 1621: -- FROM fv_facts_ussgl_accounts

1617: FROM FV_FACTS_ATTRIBUTES
1618: WHERE facts_acct_number = l_account_number
1619: AND set_of_books_id = g_set_of_books_id;
1620: -- AND EXISTS (SELECT 'X'
1621: -- FROM fv_facts_ussgl_accounts
1622: -- WHERE ussgl_account = l_account_number);
1623:
1624: -- Account Number exists in FV_FACTS_ATTRIBUTES table
1625: -- and can be used to get FACTS attributes.

Line 1657: FROM fv_facts_ussgl_accounts

1653: -- Get the USSGL/Parent account
1654: BEGIN
1655: SELECT 'X'
1656: INTO l_exists
1657: FROM fv_facts_ussgl_accounts
1658: WHERE ussgl_account = l_account_number;
1659:
1660: l_sgl_acct_num := l_account_number;
1661: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2750: FROM fv_facts_ussgl_accounts

2746: IF l_sgl_acct_num IS NULL THEN
2747: BEGIN
2748: SELECT 'X'
2749: INTO l_exists
2750: FROM fv_facts_ussgl_accounts
2751: WHERE ussgl_account = l_account_number;
2752: l_sgl_acct_num := l_account_number;
2753: EXCEPTION
2754: WHEN NO_DATA_FOUND THEN

Line 2766: FROM fv_facts_ussgl_accounts

2762:
2763: BEGIN
2764: SELECT disbursements_flag
2765: INTO l_disbursements_flag
2766: FROM fv_facts_ussgl_accounts
2767: WHERE ussgl_account = l_sgl_acct_num;
2768: EXCEPTION
2769: WHEN OTHERS THEN
2770: g_error_code := sqlcode ;

Line 4050: FROM fv_facts_ussgl_accounts

4046: SELECT ussgl_enabled_flag,
4047: reporting_type
4048: INTO l_enabled_flag,
4049: l_reporting_type
4050: FROM fv_facts_ussgl_accounts
4051: WHERE ussgl_account = p_ussgl_acct_num;
4052:
4053: p_enabled_flag := l_enabled_flag;
4054: p_reporting_type := l_reporting_type;

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

4053: p_enabled_flag := l_enabled_flag;
4054: p_reporting_type := l_reporting_type;
4055: EXCEPTION
4056: WHEN NO_DATA_FOUND THEN
4057: -- Account Number not found in FV_FACTS_USSGL_ACCOUNTS table.
4058: -- Return Nulls.
4059: p_enabled_flag := NULL;
4060: p_reporting_type := NULL;
4061: WHEN OTHERS THEN

Line 4786: FROM fv_facts_ussgl_accounts

4782: AND parent_flex_value <> 'T'
4783: AND flex_value_set_id = l_acc_val_set_id
4784: AND parent_flex_value IN
4785: (SELECT ussgl_account
4786: FROM fv_facts_ussgl_accounts
4787: WHERE ussgl_account = parent_flex_value);
4788:
4789: BEGIN
4790: -- Look for parent in FV_FACTS_ATTRIBUTES table