DBA Data[Home] [Help]

APPS.FII_PSI_BUD_ENC_DETAIL_PKG dependencies on FII_FINANCIAL_DIMENSIONS

Line 230: FROM fii_financial_dimensions

226: -- cost center dimension top node. l_child_cc_id will be used when
227: -- ((l_company_id <> 'All') AND (l_cost_center_id = 'All'))
228:
229: SELECT dbi_hier_top_node_id INTO l_child_cc_id
230: FROM fii_financial_dimensions
231: WHERE DIMENSION_SHORT_NAME = 'HRI_CL_ORGCC';
232:
233:
234: -- company dimension top node. l_child_company_id will be used when

Line 238: FROM fii_financial_dimensions

234: -- company dimension top node. l_child_company_id will be used when
235: -- ((l_company_id = 'All') AND (l_cost_center_id <> 'All'))
236:
237: SELECT dbi_hier_top_node_id INTO l_child_company_id
238: FROM fii_financial_dimensions
239: WHERE DIMENSION_SHORT_NAME = 'FII_COMPANIES';
240:
241: -- from clauses and where clauses for different combinations of
242: -- Company and Cost center parameters