APPS.AHL_PC_ASSOCIATION_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 1012: from ahl_unit_config_headers

1008:
1009: CURSOR check_unit_exists (p_unit_item_id IN NUMBER)
1010: IS
1011: select 'X'
1012: from ahl_unit_config_headers
1013: where unit_config_header_id = p_unit_item_id;
1014:
1015: CURSOR check_item_exists (p_unit_item_id IN NUMBER)
1016: IS

Line 1041: from ahl_unit_config_headers

1037:
1038: CURSOR check_unit_valid (p_unit_item_id IN NUMBER)
1039: IS
1040: select 'X'
1041: from ahl_unit_config_headers
1042: where unit_config_header_id = p_unit_item_id and
1043: trunc(sysdate) between nvl(trunc(active_start_date), trunc(sysdate)) and nvl(trunc(active_end_date), trunc(sysdate)) AND
1044: AHL_UTIL_UC_PKG.get_uc_status_code(p_unit_item_id) in ('COMPLETE', 'INCOMPLETE');
1045: -- bug 8970548 fix unit_config_status_code in ('COMPLETE', 'INCOMPLETE');

Line 1059: from ahl_unit_config_headers

1055: -- ACL :: R12 Changes
1056: CURSOR check_unit_quarantine (p_unit_item_id IN NUMBER)
1057: IS
1058: select 'X'
1059: from ahl_unit_config_headers
1060: where unit_config_header_id = p_unit_item_id AND
1061: AHL_UTIL_UC_PKG.get_uc_status_code(p_unit_item_id) IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE');
1062: -- bug 8970548 fix unit_config_status_code in ('QUARANTINE', 'DEACTIVATE_QUARANTINE');
1063: