APPS.FII_PA_BUDGET_F_C dependencies on FII_PA_BUDGET_PK

Line 28: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_BUDGET_PK';

24:
25: BEGIN
26:
27: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
28: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.FII_PA_BUDGET_PK';
29: EXECUTE IMMEDIATE l_stmt;
30: END IF;
31:
32: RETURN TRUE;

Line 84: INSERT INTO FII_PA_BUDGET_PK(

80: PROCEDURE INSERT_MISSING_RATES_IN_TMP (p_conversion_date in date)
81: IS
82:
83: BEGIN
84: INSERT INTO FII_PA_BUDGET_PK(
85: Primary_Key1,
86: PRIMARY_KEY_DATE1,
87: conversion_date )
88: SELECT

Line 450: INSERT INTO fii_pa_budget_pk

446: -- currency conversion date to the EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT
447: -- function in the base view.
448: -- PRIMARY_KEY1 and PRIMARY_KEY_DATE1 hold actual primary key.
449:
450: INSERT INTO fii_pa_budget_pk
451: (
452: Primary_Key1,
453: Primary_Key_Date1,
454: conversion_date

Line 473: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_BUDGET_PK COMPUTE STATISTICS';

469: end if;
470:
471: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
472:
473: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_BUDGET_PK COMPUTE STATISTICS';
474: EXECUTE IMMEDIATE l_stmt;
475:
476: if g_debug_flag = 'Y' then
477: edw_log.put_line('Analyzed primary key table' );

Line 632: -- the FII_PA_BUDGET_PK table

628: end if;
629:
630: -- --------------------------------------------------------
631: -- 4. Clean up any records left from previous process in
632: -- the FII_PA_BUDGET_PK table
633: -- --------------------------------------------------------
634:
635: if g_debug_flag = 'Y' then
636: edw_log.put_line(' ');

Line 747: -- Clean up any records in the FII_PA_BUDGET_PK table

743:
744: COMMIT;
745:
746: -- --------------------------------------------------------
747: -- Clean up any records in the FII_PA_BUDGET_PK table
748: -- --------------------------------------------------------
749:
750: if g_debug_flag = 'Y' then
751: edw_log.put_line(' ');