DBA Data[Home] [Help]

APPS.AHL_UC_UNITCONFIG_PUB dependencies on CSI_ITEM_INSTANCES

Line 32: csi_item_instances c

28: CURSOR get_ovns(c_uc_header_id number) IS
29: SELECT u.object_version_number,
30: c.object_version_number
31: FROM ahl_unit_config_headers u,
32: csi_item_instances c
33: WHERE u.unit_config_header_id = c_uc_header_id
34: AND u.csi_item_instance_id = c.instance_id
35: AND trunc(nvl(u.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
36: