APPS.FEM_BR_STAT_LOOKUP_PVT dependencies on FEM_STAT_LOOKUP_REL

Line 11: DELETE FROM fem_stat_lookup_rel WHERE STAT_LOOKUP_OBJ_DEF_ID = p_obj_def_id;

7: PROCEDURE DeleteObjectDefinition(p_obj_def_id NUMBER) IS
8: BEGIN
9:
10: -- First delete the Lookup join.
11: DELETE FROM fem_stat_lookup_rel WHERE STAT_LOOKUP_OBJ_DEF_ID = p_obj_def_id;
12: --Then delete the Lookup Details.
13: DELETE FROM fem_stat_lookups WHERE STAT_LOOKUP_OBJ_DEF_ID = p_obj_def_id;
14:
15: EXCEPTION

Line 56: INSERT INTO fem_stat_lookup_rel( stat_lookup_obj_def_id,

52: FROM fem_stat_lookups
53: WHERE stat_lookup_obj_def_id = p_source_obj_def_id;
54:
55: --Thereafter join the Lookup Join.
56: INSERT INTO fem_stat_lookup_rel( stat_lookup_obj_def_id,
57: stat_lookup_tbl_col,
58: relational_operand,
59: related_to_tbl_col,
60: value,

Line 78: FROM fem_stat_lookup_rel

74: FND_GLOBAL.user_id,
75: SYSDATE,
76: FND_GLOBAL.login_id,
77: 0
78: FROM fem_stat_lookup_rel
79: WHERE stat_lookup_obj_def_id = p_source_obj_def_id;
80:
81: EXCEPTION
82: