APPS.BSC_SIMULATION_VIEW_PVT dependencies on FND_FORM_FUNCTIONS_VL

Line 382: h_sql := 'SELECT function_id FROM fnd_form_functions_vl WHERE function_name = :1';

378: h_condition := 'FUNCTION_NAME =''' || l_region_code || '''';
379:
380: IF(p_table_name = 'FND_FORM_FUNCTIONS_TL')THEN
381: IF p_DbLink_Name IS NULL THEN
382: h_sql := 'SELECT function_id FROM fnd_form_functions_vl WHERE function_name = :1';
383: ELSE
384: h_sql := 'SELECT function_id FROM fnd_form_functions_vl@'|| p_DbLink_Name || ' WHERE function_name = :1';
385: END IF;
386: OPEN cd FOR h_sql USING l_region_code;

Line 384: h_sql := 'SELECT function_id FROM fnd_form_functions_vl@'|| p_DbLink_Name || ' WHERE function_name = :1';

380: IF(p_table_name = 'FND_FORM_FUNCTIONS_TL')THEN
381: IF p_DbLink_Name IS NULL THEN
382: h_sql := 'SELECT function_id FROM fnd_form_functions_vl WHERE function_name = :1';
383: ELSE
384: h_sql := 'SELECT function_id FROM fnd_form_functions_vl@'|| p_DbLink_Name || ' WHERE function_name = :1';
385: END IF;
386: OPEN cd FOR h_sql USING l_region_code;
387: FETCH cd INTO l_old_function_id;
388: CLOSE cd;

Line 1771: FROM fnd_form_functions_vl

1767: ) IS
1768:
1769: CURSOR c_form_functions IS
1770: SELECT parameters
1771: FROM fnd_form_functions_vl
1772: WHERE function_name =p_ind_Sht_Name;
1773:
1774: l_parameters FND_FORM_FUNCTIONS_VL.parameters%TYPE;
1775: l_dim_dimobjs_record BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;

Line 1774: l_parameters FND_FORM_FUNCTIONS_VL.parameters%TYPE;

1770: SELECT parameters
1771: FROM fnd_form_functions_vl
1772: WHERE function_name =p_ind_Sht_Name;
1773:
1774: l_parameters FND_FORM_FUNCTIONS_VL.parameters%TYPE;
1775: l_dim_dimobjs_record BSC_BIS_KPI_CRUD_PUB.BSC_VARCHAR2_TBL_TYPE;
1776: l_non_time_counter NUMBER;
1777: l_attribute2 ak_region_items_vl.attribute2%TYPE;
1778: l_default_value NUMBER;