APPS.FTP_TP_PKG dependencies on FEM_OBJECT_CATALOG_B

Line 103: fem_object_catalog_b b,

99: a.effective_start_date,
100: a.effective_end_date
101: into OBJ_INFO
102: from fem_object_definition_b a,
103: fem_object_catalog_b b,
104: fem_global_vs_combo_defs c
105: where a.object_id = OBJ_ID
106: and a.old_approved_copy_flag = 'N'
107: and trunc(EFFECTIVE_DATE) between a.effective_start_date

Line 147: from fem_object_catalog_b where object_id = tp_obj_id;

143: where object_definition_id = process_info.obj_id;
144:
145: -- Get the local value combo of the tp_object_id;
146: select local_vs_combo_id into combo_id
147: from fem_object_catalog_b where object_id = tp_obj_id;
148:
149: -- Now the valuset id of the line item and org unitl.
150: select value_set_id into ORG_VAL_SET
151: from fem_global_vs_combo_defs where dimension_id = 8 and

Line 183: fem_object_catalog_b cat,

179: cursor c(id number,eff_date date) is
180: select
181: cat.object_id hierarchy_id
182: from
183: fem_object_catalog_b cat,
184: fem_object_dependencies dep,
185: fem_object_definition_b def
186: where
187: def.object_id = id and