APPS.FEM_PL_PKG dependencies on FEM_OBJECT_DEPENDENCIES

Line 735: FROM fem_object_dependencies

731: AND old_approved_copy_flag = 'N';
732:
733: CURSOR c_object_dependencies (p_object_id NUMBER) IS
734: SELECT object_definition_id
735: FROM fem_object_dependencies
736: WHERE required_object_id = p_object_id;
737:
738: C_API_NAME CONSTANT VARCHAR2(30) := 'can_delete_object';
739: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

Line 2030: FROM fem_object_dependencies D,

2026: -- effective date.
2027: ------------------------------------------------------------------------
2028: CURSOR c1 IS
2029: SELECT D.required_object_id
2030: FROM fem_object_dependencies D,
2031: fem_object_definition_b B
2032: WHERE D.required_object_id = B.object_id
2033: AND B.effective_start_date <= p_effective_date
2034: AND B.effective_end_date >= p_effective_date