APPS.FTP_TP_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 104: fem_global_vs_combo_defs c

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
108: and nvl(a.effective_end_date,

Line 151: from fem_global_vs_combo_defs where dimension_id = 8 and

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
152: global_vs_combo_id = combo_id;
153:
154: -- Now the valuset id of the line item and org unitl.
155: select value_set_id into LN_ITEM_VAL_SET

Line 156: from fem_global_vs_combo_defs where dimension_id = 14 and

152: global_vs_combo_id = combo_id;
153:
154: -- Now the valuset id of the line item and org unitl.
155: select value_set_id into LN_ITEM_VAL_SET
156: from fem_global_vs_combo_defs where dimension_id = 14 and
157: global_vs_combo_id = combo_id;
158:
159: -- Get Source System Code
160: EXECUTE IMMEDIATE 'select source_system_code from fem_source_systems_vl