APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_WARRANTY_CONTRACTS_B

Line 1110: From ahl_warranty_contracts_b

1106: (p_x_sr_task_rec.warranty_contract_id is not null and
1107: p_x_sr_task_rec.warranty_contract_id <> FND_API.G_MISS_NUM)) THEN
1108:
1109: Select warranty_contract_id into p_x_sr_task_rec.warranty_contract_id
1110: From ahl_warranty_contracts_b
1111: Where warranty_contract_id = p_x_sr_task_rec.warranty_contract_id
1112: and item_instance_id = p_x_sr_task_rec.instance_id
1113: and contract_status_code = 'ACTIVE';
1114:

Line 1119: From ahl_warranty_contracts_b

1115: ELSIF (p_x_sr_task_rec.warranty_contract_number is not null and
1116: p_x_sr_task_rec.warranty_contract_number <> FND_API.G_MISS_NUM) THEN
1117:
1118: Select warranty_contract_id into p_x_sr_task_rec.warranty_contract_id
1119: From ahl_warranty_contracts_b
1120: Where contract_number = p_x_sr_task_rec.warranty_contract_number
1121: and item_instance_id = p_x_sr_task_rec.instance_id
1122: and contract_status_code = 'ACTIVE';
1123: END IF;