APPS.AHL_UC_ACL_WF_APPR_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 14: FROM ahl_unit_config_headers

10: ,name
11: ,object_version_number
12: ,unit_config_status_code
13: ,active_uc_status_code
14: FROM ahl_unit_config_headers
15: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
16: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
17: AND unit_config_header_id = c_uc_header_id;
18:

Line 1300: FROM ahl_unit_config_headers

1296: SELECT unit_config_header_id,
1297: name,
1298: unit_config_status_code,
1299: active_uc_status_code
1300: FROM ahl_unit_config_headers
1301: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1302: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1303: AND unit_config_header_id = c_uc_header_id
1304: AND object_version_number = c_object_version_number;

Line 1525: FROM ahl_unit_config_headers

1521: SELECT unit_config_header_id,
1522: name,
1523: unit_config_status_code,
1524: active_uc_status_code
1525: FROM ahl_unit_config_headers
1526: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1527: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1528: AND unit_config_header_id = c_uc_header_id
1529: AND object_version_number = c_object_version_number;

Line 1602: UPDATE ahl_unit_config_headers

1598: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1599: RAISE FND_API.G_EXC_ERROR;
1600: END IF;
1601:
1602: UPDATE ahl_unit_config_headers
1603: SET active_uc_status_code = l_next_status,
1604: object_version_number = l_object_version_number + 1,
1605: last_update_date = sysdate,
1606: last_updated_by = to_number(fnd_global.login_id),