APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on FV_FACTS_ATTRIBUTES

Line 139: -- in FV_FACTS_ATTRIBUTES table and is not an USSGL account

135: v_fund_val Varchar2(25) ;
136: v_sgl_acct_num number ;
137:
138: -- This flag is set to 'Y' when a account number is found
139: -- in FV_FACTS_ATTRIBUTES table and is not an USSGL account
140: v_acct_attr_flag Varchar2(1) ;
141: --Start Bug 2464961--
142: v_amount_dr NUMBER ;
143: v_amount_cr NUMBER ;

Line 884: from FV_FACTS_ATTRIBUTES

880: -- Process Account Number Validation . Just get the Parent acct.
881: Begin
882: Select 'X'
883: into vl_exists
884: from FV_FACTS_ATTRIBUTES
885: where facts_acct_number = v_acct_num
886: and set_of_books_id = vp_set_of_books_id;
887:
888:

Line 889: -- Account Number exists in FV_FACTS_ATTRIBUTES table

885: where facts_acct_number = v_acct_num
886: and set_of_books_id = vp_set_of_books_id;
887:
888:
889: -- Account Number exists in FV_FACTS_ATTRIBUTES table
890: -- and can be used to get FACTS attributes.
891: LOAD_FACTS_ATTRIBUTES (v_acct_num, v_fund_val) ;
892: vl_attributes_found := 'Y' ;
893: --VP_ERRBUF := 'LOAD ATTRIBUTES FOR ACCT:'||v_acct_num||'-'||v_fund_val;

Line 1189: from FV_FACTS_ATTRIBUTES

1185: -- Process Account Number Validation . Just get the Parent acct.
1186: Begin
1187: Select 'X'
1188: into vl_exists
1189: from FV_FACTS_ATTRIBUTES
1190: where facts_acct_number = v_acct_num
1191: and set_of_books_id = vp_set_of_books_id;
1192:
1193:

Line 1194: -- Account Number exists in FV_FACTS_ATTRIBUTES table

1190: where facts_acct_number = v_acct_num
1191: and set_of_books_id = vp_set_of_books_id;
1192:
1193:
1194: -- Account Number exists in FV_FACTS_ATTRIBUTES table
1195: -- and can be used to get FACTS attributes.
1196: LOAD_FACTS_ATTRIBUTES (v_acct_num, v_fund_val) ;
1197: vl_attributes_found := 'Y' ;
1198: /* VP_ERRBUF := 'LOAD ATTRIBUTES FOR ACCT:'||v_acct_num||

Line 1458: FROM FV_FACTS_ATTRIBUTES

1454: BEGIN
1455:
1456: SELECT balance_type
1457: INTO va_balance_type_flag
1458: FROM FV_FACTS_ATTRIBUTES
1459: WHERE Facts_Acct_Number = vl_sgl_acct_num
1460: and set_of_books_id = vp_set_of_books_id ;
1461:
1462: EXCEPTION

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

1666: -- -------------------------------------------------------------------
1667: -- PROCEDURE LOAD_FACTS_ATTRIBUTES
1668: -- -------------------------------------------------------------------
1669: -- This procedure selects the attributes for the Account number
1670: -- segment from FV_FACTS_ATTRIBUTES table and load them into global
1671: -- variables for usage in the FACTS Main process. It also calculates
1672: -- one time pull up values for the account number that does not
1673: -- require drill down into GL transactions.
1674: -- ------------------------------------------------------------------

Line 1717: FROM FV_FACTS_ATTRIBUTES

1713: va_deficiency_flag,
1714: va_function_flag,
1715: va_advance_flag, /* Bug No: 2494754 */
1716: va_transfer_ind
1717: FROM FV_FACTS_ATTRIBUTES
1718: WHERE Facts_Acct_Number = acct_num
1719: AND set_of_books_id = vp_set_of_books_id;
1720: Exception
1721:

Line 2045: -- Look for parent in FV_FACTS_ATTRIBUTES table

2041:
2042: --vp_errbuf := 'SGL Parent Account:'||sgl_acct_num||'-'||acct_num;
2043: --fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2044: Begin
2045: -- Look for parent in FV_FACTS_ATTRIBUTES table
2046: Select 'X'
2047: Into vl_exists
2048: From fv_facts_attributes
2049: where facts_acct_number = sgl_acct_num

Line 2048: From fv_facts_attributes

2044: Begin
2045: -- Look for parent in FV_FACTS_ATTRIBUTES table
2046: Select 'X'
2047: Into vl_exists
2048: From fv_facts_attributes
2049: where facts_acct_number = sgl_acct_num
2050: and set_of_books_id = vp_set_of_books_id;
2051:
2052: --vp_errbuf := 'SQL Account Exists:'||vl_exists;