DBA Data[Home] [Help]

APPS.PFT_PPROFCAL_MASTER_PUB dependencies on FEM_OBJECT_CATALOG_B

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

602: ,NULL)
603: ,g_default_fetch_limit);
604:
605: ----------------------------------------------------------------------------
606: -- Get the object info from fem_object_catalog_b for the object_id passed in
607: ----------------------------------------------------------------------------
608: FEM_ENGINES_PKG.Tech_Message (
609: p_severity => g_log_level_3
610: ,p_module => G_BLOCK||'.'||l_api_name

Line 618: FROM fem_object_catalog_b

614: SELECT object_type_code
615: ,local_vs_combo_id
616: INTO x_param_rec.obj_type_code
617: ,x_param_rec.local_vs_combo_id
618: FROM fem_object_catalog_b
619: WHERE object_id = x_param_rec.obj_id;
620:
621: EXCEPTION
622: WHEN OTHERS THEN

Line 1974: ,fem_object_catalog_b o

1970:
1971: SELECT d.object_definition_id
1972: INTO x_obj_def_id
1973: FROM fem_object_definition_b d
1974: ,fem_object_catalog_b o
1975: WHERE o.object_id = p_object_id
1976: AND o.object_type_code = p_object_type_code
1977: AND d.object_id = o.object_id
1978: AND p_effective_date BETWEEN d.effective_start_date AND d.effective_end_date