DBA Data[Home] [Help]

APPS.FII_EA_ACCT_DETAIL_PKG dependencies on FII_FINANCIAL_DIMENSIONS

Line 234: FROM fii_financial_dimensions

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

Line 242: FROM fii_financial_dimensions

238: -- company dimension top node. l_child_company_id will be used when
239: -- ((l_company_id = 'All') AND (l_cost_center_id <> 'All'))
240:
241: SELECT dbi_hier_top_node_id INTO l_child_company_id
242: FROM fii_financial_dimensions
243: WHERE DIMENSION_SHORT_NAME = 'FII_COMPANIES';
244:
245:
246: -- from clauses and where clauses for different combinations of