APPS.FII_FA_EXP_B_C dependencies on FII_FA_EXP_T

Line 139: FROM fii_fa_exp_t

135: currency_code,
136: decode( prim_conversion_rate,
137: -3, to_date( '01/01/1999', 'MM/DD/YYYY' ),
138: least(sysdate, effective_date)) effective_date
139: FROM fii_fa_exp_t
140: WHERE prim_conversion_rate < 0;
141:
142: cursor SecMissingRate is
143: SELECT DISTINCT

Line 148: FROM fii_fa_exp_t

144: currency_code,
145: decode( sec_conversion_rate,
146: -3, to_date( '01/01/1999', 'MM/DD/YYYY' ),
147: least(sysdate, effective_date) ) effective_date
148: FROM fii_fa_exp_t
149: WHERE sec_conversion_rate < 0;
150: */
151:
152: BEGIN

Line 428: FROM fii_fa_exp_t

424:
425: begin
426: SELECT 1
427: INTO l_count2
428: FROM fii_fa_exp_t
429: WHERE ROWNUM = 1;
430: exception
431: when NO_DATA_FOUND then
432: l_count2 := 0;

Line 789: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_T',

785: P_RETCODE => l_ret_code);
786: END IF;
787:
788: IF (g_truncate_stg) THEN
789: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_T',
790: P_RETCODE => l_ret_code);
791:
792: END IF;
793:

Line 1267: from fii_fa_exp_t

1263: from (
1264: select distinct
1265: FUNCTIONAL_CURRENCY cc,
1266: account_date dt
1267: from fii_fa_exp_t
1268: );
1269:
1270:
1271: --Call FND_STATS to collect statistics after populating the table

Line 1285: /* + no_merge parallel(fii_fa_exp_t)*/

1281: end if;
1282:
1283: */
1284:
1285: /* + no_merge parallel(fii_fa_exp_t)*/
1286:
1287: EXCEPTION
1288: WHEN OTHERS Then
1289: g_retcode := -1;

Line 2160: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_T',

2156: IF g_debug_flag = 'Y' then
2157: FII_UTIL.put_line('Running in Initial Load mode, truncate STG, summary and other processing tables.');
2158: END IF;
2159:
2160: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_T',
2161: P_RETCODE => l_ret_code);
2162:
2163: FII_UTIL.TRUNCATE_TABLE(p_table_name => 'FII_FA_EXP_F',
2164: P_RETCODE => l_ret_code);

Line 2686: -- or missing time dimension record in the fii_fa_exp_t

2682:
2683: -----------------------------------------------------------------
2684: -- If all the child process completes successfully then Invoke
2685: -- Summary_err_check routine to check for any missing rates record
2686: -- or missing time dimension record in the fii_fa_exp_t
2687: -- table.
2688: -----------------------------------------------------------------
2689: g_phase:= 'Summarization Error Check';
2690: if g_debug_flag = 'Y' then