DBA Data[Home] [Help]

APPS.PFT_ACCTRELCONS_PUB dependencies on FEM_OBJECT_CATALOG_B

Line 664: -- Get the object info from fem_object_catalog_b for the object_id passed in

660: ,NULL)
661: ,g_default_fetch_limit);
662:
663: ----------------------------------------------------------------------------
664: -- Get the object info from fem_object_catalog_b for the object_id passed in
665: ----------------------------------------------------------------------------
666: fem_engines_pkg.tech_message (
667: p_severity => g_log_level_3
668: ,p_module => G_BLOCK||'.'||l_api_name

Line 676: FROM fem_object_catalog_b

672: SELECT object_type_code
673: ,local_vs_combo_id
674: INTO x_param_rec.obj_type_code
675: ,x_param_rec.local_vs_combo_id
676: FROM fem_object_catalog_b
677: WHERE object_id = x_param_rec.obj_id;
678:
679: EXCEPTION
680: WHEN OTHERS THEN

Line 2445: ,fem_object_catalog_b o

2441:
2442: SELECT d.object_definition_id
2443: INTO x_obj_def_id
2444: FROM fem_object_definition_b d
2445: ,fem_object_catalog_b o
2446: WHERE o.object_id = p_object_id
2447: AND o.object_type_code = p_object_type_code
2448: AND d.object_id = o.object_id
2449: AND p_effective_date BETWEEN d.effective_start_date