APPS.ENG_PROPAGATION_LOG_UTIL dependencies on ENG_CHANGE_LOGS_B

Line 347: FROM eng_change_logs_b

343: , cp_local_org_id NUMBER
344: , cp_change_map_id NUMBER)
345: IS
346: SELECT change_log_id
347: FROM eng_change_logs_b
348: WHERE change_id = cp_change_id
349: AND local_organization_id = cp_local_org_id
350: AND log_type_code <> 'INFO'
351: AND FND_API.G_TRUE = p_delete_map_logs

Line 356: l_log_type_code eng_change_logs_b.log_type_code%TYPE;

352: AND change_propagation_map_id = cp_change_map_id;
353:
354: l_new_log_id NUMBER;
355: l_val VARCHAR2(200);
356: l_log_type_code eng_change_logs_b.log_type_code%TYPE;
357: BEGIN
358:
359: --
360: -- Delete Log messages if required.