APPS.FV_FACTS_TRX_REGISTER dependencies on FV_FACTS_ATTRIBUTES

Line 840: --l_balance_type_flag FV_FACTS_ATTRIBUTES.balance_type%TYPE;

836: l_name VARCHAR2(150);
837: l_valid_flag VARCHAR2(2);
838: l_feeder_flag VARCHAR2(1);
839: l_stage NUMBER(2);
840: --l_balance_type_flag FV_FACTS_ATTRIBUTES.balance_type%TYPE;
841: l_sob NUMBER(15);
842: l_coa NUMBER(15);
843: --l_period_num_low NUMBER(15);
844: --l_period_num_high NUMBER(15);

Line 1686: FROM FV_FACTS_ATTRIBUTES

1682: -- Get the account or the parent account
1683: BEGIN
1684: SELECT 'X'
1685: INTO l_exists
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

Line 1693: -- Account Number exists in FV_FACTS_ATTRIBUTES table

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.
1695: -- l_sgl_acct_num := l_account_number;
1696:
1697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4652: -- segment from FV_FACTS_ATTRIBUTES table and load them into global

4648: -- -------------------------------------------------------------------
4649: -- PROCEDURE LOAD_FACTS_ATTRIBUTES
4650: -- -------------------------------------------------------------------
4651: -- This procedure selects the attributes for the Account number
4652: -- segment from FV_FACTS_ATTRIBUTES table and load them into global
4653: -- variables for usage in the FACTS Main process. It also calculates
4654: -- one time pull up values for the account number that does not
4655: -- require drill down into GL transactions.
4656: -- ------------------------------------------------------------------

Line 4712: FROM FV_FACTS_ATTRIBUTES

4708: g_govt_non_govt_ind,
4709: g_exch_non_exch_ind,
4710: g_cust_non_cust_ind,
4711: g_budget_subfunction_ind
4712: FROM FV_FACTS_ATTRIBUTES
4713: WHERE Facts_Acct_Number = acct_num
4714: AND set_of_books_id = g_set_of_books_id;
4715: g_attributes_found :='Y';
4716: EXCEPTION

Line 5067: -- Look for parent in FV_FACTS_ATTRIBUTES table

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
5068: SELECT 'X'
5069: INTO l_exists
5070: FROM fv_facts_attributes
5071: WHERE facts_acct_number = sgl_acct_num

Line 5070: FROM fv_facts_attributes

5066: BEGIN
5067: -- Look for parent in FV_FACTS_ATTRIBUTES table
5068: SELECT 'X'
5069: INTO l_exists
5070: FROM fv_facts_attributes
5071: WHERE facts_acct_number = sgl_acct_num
5072: AND set_of_books_id = g_set_of_books_id;
5073: -- Return the account Number
5074: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN