APPS.FII_PA_BUDGET_HOOK dependencies on FII_PA_BUDGET_FSTG

Line 65: update fii_pa_budget_fstg fstg

61:
62: -- Step 4. update PROJECT_ORG_FK in the fact staging table
63: -- with Task Owning Organization from the Task Level table
64:
65: update fii_pa_budget_fstg fstg
66: set project_org_fk =
67: (
68: select denorm_task_org_fk
69: from edw_proj_task_ltc task

Line 82: update fii_pa_budget_fstg fstg

78: -- table by Project Dimension collection process between Steps 3 and 4.
79: -- Step 5 guarantees that FSTG and F tables are always in sync in
80: -- respect to the LTC tables.
81:
82: update fii_pa_budget_fstg fstg
83: set project_org_fk =
84: (
85: select attribute3
86: from fii_system_event_log log