DBA Data[Home] [Help]

APPS.PFT_PROFITAGG_PUB dependencies on FEM_OBJECT_CATALOG_B

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

618: x_param_rec.pgm_id := FND_GLOBAL.conc_program_id;
619: x_param_rec.pgm_app_id := FND_GLOBAL.prog_appl_id;
620:
621: ----------------------------------------------------------------------------
622: -- Get the object info from fem_object_catalog_b for the object_id passed in
623: ----------------------------------------------------------------------------
624: fem_engines_pkg.tech_message (
625: p_severity => g_log_level_3
626: ,p_module => G_BLOCK||'.'||l_api_name

Line 634: FROM fem_object_catalog_b

630: SELECT object_type_code
631: ,local_vs_combo_id
632: INTO x_param_rec.obj_type_code
633: ,x_param_rec.local_vs_combo_id
634: FROM fem_object_catalog_b
635: WHERE object_id = x_param_rec.obj_id;
636:
637: EXCEPTION
638: WHEN OTHERS THEN

Line 2652: ,fem_object_catalog_b o

2648:
2649: SELECT d.object_definition_id
2650: INTO x_obj_def_id
2651: FROM fem_object_definition_b d
2652: ,fem_object_catalog_b o
2653: WHERE o.object_id = p_object_id
2654: AND o.object_type_code = p_object_type_code
2655: AND d.object_id = o.object_id
2656: AND p_effective_date BETWEEN d.effective_start_date