APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_OBJECT_TYPES_VL

Line 548: fem_object_types_vl t, fem_folders_vl f

544: d.effective_start_date, d.effective_end_date,
545: sysdate, FND_GLOBAL.User_ID,
546: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
547: FROM fem_object_definition_vl d, fem_object_catalog_vl c,
548: fem_object_types_vl t, fem_folders_vl f
549: WHERE d.object_definition_id = p_obj_def_id
550: AND d.object_id = c.object_id
551: AND c.object_type_code = t.object_type_code
552: AND c.folder_id = f.folder_id;

Line 582: fem_object_types_vl t, fem_folders_vl f, fem_dimensions_vl dim

578: sysdate, FND_GLOBAL.User_ID,
579: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
580: FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,
581: fem_object_definition_vl d, fem_object_catalog_vl c,
582: fem_object_types_vl t, fem_folders_vl f, fem_dimensions_vl dim
583: WHERE b.object_definition_id = p_obj_def_id
584: AND b.object_definition_id = d.object_definition_id
585: AND d.object_id = c.object_id
586: AND c.object_type_code = t.object_type_code

Line 2398: FROM fem_object_types_vl

2394: last_updated_by, last_update_date, last_update_login)
2395: VALUES(
2396: FND_GLOBAL.Conc_Request_Id, v_request_date, v_request_name,
2397: p_rule_type, (SELECT object_type_name
2398: FROM fem_object_types_vl
2399: WHERE object_type_code = p_rule_type),
2400: p_ledger_id, (SELECT ledger_name
2401: FROM fem_ledgers_vl
2402: WHERE ledger_id = p_ledger_id),