APPS.AHL_PC_ASSOCIATION_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 1008: from ahl_unit_config_headers

1004:
1005: CURSOR check_unit_exists (p_unit_item_id IN NUMBER)
1006: IS
1007: select 'X'
1008: from ahl_unit_config_headers
1009: where unit_config_header_id = p_unit_item_id;
1010:
1011: CURSOR check_item_exists (p_unit_item_id IN NUMBER)
1012: IS

Line 1037: from ahl_unit_config_headers

1033:
1034: CURSOR check_unit_valid (p_unit_item_id IN NUMBER)
1035: IS
1036: select 'X'
1037: from ahl_unit_config_headers
1038: where unit_config_header_id = p_unit_item_id and
1039: trunc(sysdate) between nvl(trunc(active_start_date), trunc(sysdate)) and nvl(trunc(active_end_date), trunc(sysdate)) and
1040: unit_config_status_code in ('COMPLETE', 'INCOMPLETE');
1041:

Line 1054: from ahl_unit_config_headers

1050: -- ACL :: R12 Changes
1051: CURSOR check_unit_quarantine (p_unit_item_id IN NUMBER)
1052: IS
1053: select 'X'
1054: from ahl_unit_config_headers
1055: where unit_config_header_id = p_unit_item_id and
1056: unit_config_status_code in ('QUARANTINE', 'DEACTIVATE_QUARANTINE');
1057:
1058: BEGIN